Oracle 16进制转字符串

来自泡泡学习笔记
跳到导航 跳到搜索

16进制数值记录为字符串

Select    hextoraw('313233') From dual;


16进制数表示的字符记录为字符串

Select    utl_raw.cast_to_raw('今天天气真好'),utl_raw.cast_to_varchar2( utl_raw.cast_to_raw('今天天气真好')) From dual;