SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequence number start with 00001

Sarah QASep 3 2009 — edited Oct 25 2009

hi all
i want to create sequence i want it starts with 000001,and after creating of sequence it return the values like this 000002,000003,000004 and so on
is it possible that it start with 000001?

CREATE SEQUENCE SARAHSEQuence
INCREMENT BY 1
START WITH 000001

Sarah

This post has been answered by Magoo on Sep 3 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2009

Added on Sep 3 2009

7 comments

8,561 views