Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to generate alpha-numeric sequence in Oracle?
kranilk_at_gmail.com wrote:
> Hello All,
>
> After searching the web unsuccessfully for what I am looking for, I
> have come here.
> I need to generate a 6 digit alpha-numeric sequence of values that
> looks like the following.
> 00001A
> 00001B
> :
> 00001Z
> 00002A
> 00002B
> :
What about creating a regular sequence, then using this: http://www.oracle.com/technology/sample_code/products/rdb/files/convert_hex.txt
to create your requisite values?
Alex
http://www.lifesabirch.org/
Received on Wed Nov 01 2006 - 13:32:36 CST