Oracle Blob字段的查询和插入
oracle内置函数
- blob 转成字符串:utl_raw.cast_to_varchar2
- blob 截取字符串:dbms_lob.substr
- 字符串转blob: to_blob
插入
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))