I must generate 16 char length hex decimal value as sequence. My database is Oracle and want to know can you really achieve this? I checked the succession in Oracle however i think its just for numericals.

Any idea could be great help.
Thanks ahead of time,
Abdel Olakara

Yes, Oracle sequences are integers.

To be able to make use of a sequence to develop a 16 character length hexadecimal value, you should utilize TO_CHAR:


List of supported [cde]/[cde] formats.