How do I create a sequence that gives me alpha numeric values. (can we do this?)
Thanks in Advance.
Printable View
How do I create a sequence that gives me alpha numeric values. (can we do this?)
Thanks in Advance.
select
chr( mod(test_seq.nextval, ascii('z')-ascii(A) )+ascii(A) )
from dual
a sequence always gives a numeric value only. But when you are inserting values, you may concatenate this number with some alphabets and insert a alphanumeric string.