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!

how to generate a special sequence?

ScottZhengJul 10 2008 — edited Jul 10 2008
Hi there,

I need to generate a special sequence like this:
A0A0A0
A0A0A1
A0A0A2
..
A0A0A9 ---when add 1 to 9, it will be from A9 to B0
A0A0B0
...
A0A0Y9
A0A0Z0
...
A0A0Z9
A0A1A0
...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2008
Added on Jul 10 2008
7 comments
529 views