oracle转换函数utl_raw

SQL> desc utl_raw
FUNCTION CAST_TO_NVARCHAR2 RETURNS NVARCHAR2
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 R                              RAW                     IN
FUNCTION CAST_TO_RAW RETURNS RAW
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 C                              VARCHAR2                IN
 
CAST_TO_VARCHAR2 Function:
Converts a RAW represented using n data bytes into VARCHAR2 with n data bytes

 

CAST_TO_RAW Function
Converts a VARCHAR2 represented using n data bytes into a RAW with n data bytes
 
SQL> col name for a40;
SQL> select utl_raw.cast_to_raw('甲骨文') name from dual;

NAME
----------------------------------------
E794B2E9AAA8E69687

 

SQL> select utl_raw.cast_to_varchar2('E794B2E9AAA8E69687') name  from dual;

NAME
----------------------------------------
甲骨文

 

SQL> select dump('甲骨文' ,16) name from dual;

NAME
----------------------------------------
Typ=96 Len=9: e7,94,b2,e9,aa,a8,e6,96,87