OraQA

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.

Filed under Question, SQL. Follow any responses to this entry through this RSS 2.0 feed.

3 Responses to “Create Alphanumeric Sequence in SQL?”

hsafra Says:
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.

Laurent Schneider Says:
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;