注：本文来源于《》

插入

UPDATE cmm05 SET OUTFILE = to_blob('12345690')；

 

查询：

SELECT utl_raw.cast_to_varchar2(OUTFILE) FROM table_name

 

分段查询：

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