Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2511
  • Last Modified:

function to convert raw datatype into ascii

Is there any function to convert raw datatype into ascii in Oracle?
0
prashant_n_mhatre
Asked:
prashant_n_mhatre
1 Solution
 
leolkkCommented:
RAWTOHEX(rawvalue).

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


reverse is:
HEXTORAW
0
 
vanmeerendonkCommented:
sorry, breaking in...
use UTL_RAW.CAST_TO_VARCHAR2(<raw value>)

UTL_RAW is a very handy package for RAW-handling
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now