Hexadecimal sequence in Oracle

Question

Hi all,

I would like to generate 16 char length hex decimal value as sequence. My database is Oracle and would like to know is it possible to do so? I checked the SEQUENCE in Oracle but I think its only for numericals.

Any idea would be great help.
Thanks in advance,
Abdel Olakara

Answer 1

Yes, Oracle sequences are integers.

In order to use a sequence to generate a 16 character length hexadecimal value, you need to use TO_CHAR:

TO_CHAR(your_sequence.NEXTVAL,'XXXXXXXXXXXXXXXX')

List of supported TO_CHAR/TO_NUMBER formats.