-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|