Skip to Main Content
Forums

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!

Can i create sequences padded with 0's in the beginning, for e.g. 00500

578308May 18 2007 — edited May 18 2007
Hi,

If i want to create a sequence starting from 00500 to 99999, how can i do that?
Please note the sequence should start with 00500 and not 500. I tried creating one, but 00500 got converted to 500.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2007
Added on May 18 2007
11 comments
1,486 views