select utl_raw.cast_to_varchar2(dbms_lob.substr(log_data_details)) from JFP_TWGCB_MISLOG where utl_raw.cast_to_varchar2(DBMS_LOB.SUBSTR(log_data_details,2000,1))
这里两个oralce 内置函数
blob 转成字符串:utl_raw.cast_to_varchar2
blob 截取字符串:dbms_lob.substr
这里两个oralce 内置函数
blob 转成字符串:utl_raw.cast_to_varchar2
blob 截取字符串:dbms_lob.substr