oracle内置函数：search DB blob字段显示出来

oracle内置函数：search DB blob字段显示出来

 

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

 

http://www.htsjk.com/oracle/21928.html www.htsjk.Com true http://www.htsjk.com/oracle/21928.html NewsArticle oracle内置函数：search DB blob字段显示出来 oracle内置函数：search DB blob字段显示出来 select utl_raw.cast_to_varchar2(dbms_lob.substr(log_data_details)) from JFP_TWGCB_MISLOG where utl_raw.cast_to_varchar2(DBMS_LOB.SUB...