개인적인 정리

[Oracle] RAWTOHEX() 본문

DB/ORACLE

[Oracle] RAWTOHEX()

yeon.Biju 2020. 4. 14. 11:08

오라클 RAWTOHEX()

 

RAWTOHEX()

   -

 

RAWTOHEX(raw)

의 형태

 

RAWTOHEX converts raw to a character value containing its hexadecimal representation.

 

As a SQL built-in function, RAWTOHEX accepts an argument of any scalar data type other than LONG, LONG RAW, CLOB, BLOB, or BFILE. It returns a VARCHAR2 value with the hexadecimal representation of bytes that make up the value of raw. Each byte is represented by two hexadecimal digits. 

'DB > ORACLE' 카테고리의 다른 글

[Oracle]REGEXP_SUBSTR()  (0) 2020.06.08
[Oracle]REGEXP_REPLACE()  (0) 2020.06.08
[Oracle] REGEXP_INSTR()  (0) 2020.04.21
[ORACLE] REGEXP_COUNT()  (0) 2020.04.21
[Oracle]RATIO_TO_REPORT()  (0) 2020.04.14
[Oracle] RANK()  (0) 2020.04.14
[Oracle] POWER()  (0) 2020.04.14
[Oracle] PERCENT_RANK()  (0) 2020.04.14
Comments