UTL_RAW
| 函数名 |
参数类型 |
结果类型 |
描述 |
| cast_to_raw |
varchar2 |
raw |
将输入的varchar2类型的数据转换成raw类型的数据 |
| cast_to_varchar2 |
raw |
varchar2 |
将输入的raw类型数据转换回varchar2类型 |
vastbase=# select utl_raw.cast_to_raw('test') from dual;
cast_to_raw
-------------
74657374
(1 row)
vastbase=# select utl_raw.cast_to_raw('测试') from dual;
cast_to_raw
--------------
E6B58BE8AF95
(1 row)
vastbase=# select utl_raw.cast_to_varchar2('74657374') from dual;
cast_to_varchar2
------------------
test
(1 row)
vastbase=# select utl_raw.cast_to_varchar2('E6B58BE8AF95') from dual;
cast_to_varchar2
------------------
测试
(1 row)
