CODEWITHSUNDEEP
sqldatabaseoracle-databaseplsqlsequence
Abdel Raoof Olakara
Abdel Raoof Olakara

Reputation: 19353

Hexadecimal sequence in Oracle

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

Upvotes: 2

Views: 3360

Answers (1)

OMG Ponies
OMG Ponies

Reputation: 332621

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.

Upvotes: 6

Related Questions