Create Alphanumeric Sequence in SQL?
August 10th, 2008 By Chetana
How can I create an alphanumeric sequence in SQL (without using the decode function and all)? I’m using SQL*Plus. Thanks.
2 Responses to “Create Alphanumeric Sequence in SQL?”
Leave a Reply
You must be logged in to post a comment.
August 10th, 2008 at 11:53 pm
You need to give more specs for the question: What letter are acceptable? What letters aren’t? Do you need special ordering? What about gaps?
I’d wrap an Oracle sequence in a function that translates the number from the sequence to a string using the specs you need.
August 11th, 2008 at 2:08 am
if you like a Base64 format, maybe this…
select utl_raw.cast_to_varchar2( utl_encode.base64_encode( utl_raw.cast_from_binary_integer( lsc_s.nextval ) ) ) from dual;