RAWTOHEX 对比 HEXTORAW

Question

select RAWTOHEX('001w1w')   from dual;
结果：303031773177
而使用select    HEXTORAW('303031773177')  from dual;
结果却不是001w1w 很是迷惑啊；如何能够转回去啊

Answer 1

得进行转换：select RAWTOHEX('001w1w') from dual;
SELECT UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('303031773177')) FROM DUAL;RAWTOHEX('00 
------------ 
303031773177 
Number of rows returned: 1
Query executed in 0 ms.UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW('303031773177'))                                                                                                                                                                                                              
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
001w1w                                                                                                                                                                                                                                                          
Number of rows returned: 1
Query executed in 0 ms.overall execution time 31 ms