function to convert raw datatype into ascii

Is there any function to convert raw datatype into ascii in Oracle?
LVL 4
prashant_n_mhatreAsked:
Who is Participating?
 
vanmeerendonkConnect With a Mentor Commented:
sorry, breaking in...
use UTL_RAW.CAST_TO_VARCHAR2(<raw value>)

UTL_RAW is a very handy package for RAW-handling
0
 
leolkkCommented:
RAWTOHEX(rawvalue).

return character string containing hexadecimal represntation. each byte of rawvalue is converted into a two-character string.


reverse is:
HEXTORAW
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.