Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tag length value to hexadecimal

Daniyal AhmedNov 28 2021

Tag = 01
length = 12
value = Bobs Records
hex = 010c426f6273205265636f726473
when i run
SELECT RAWTOHEX('Bobs Records') FROM dual
i get my desire result which is '426f6273205265636f726473'
and when i run
SELECT LENGTHB('Bobs Records') FROM dual;
i get the bytes which is 12
my question is how can i convert tlv to hex
010c426f6273205265636f726473
This post has been answered by cormaco on Nov 28 2021
Jump to Answer

Comments

Post Details

Added on Nov 28 2021
#database, #developer, #pl-sql, #sql
3 comments
1,027 views