Oracle Blob字段的查询和插入

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))