because it's BLOB , you can not use like that ,
select mlxh from zlmlnr WHERE dbms_lob.instr(nr,'中国',1,1)>0; is for CLOB column正确用法是:
select mlxh from zlmlnr
WHERE dbms_lob.instr(nr,UTL_RAW.CAST_TO_RAW('中国'),1,1)>0
select mlxh from zlmlnr WHERE dbms_lob.instr(nr,'中国',1,1)>0; is for CLOB column正确用法是:
select mlxh from zlmlnr
WHERE dbms_lob.instr(nr,UTL_RAW.CAST_TO_RAW('中国'),1,1)>0
SQL> select 1 from bb where dbms_lob.instr(d,'34',1,1)>1; 1
----------
1
返之这样会返会null值.
SQL> select 1 from bb where dbms_lob.instr(d,utl_raw.cast_to_raw('34'),1,1)>1; 1
----------根据
function insstr(lob_loc in blob,
pattern in raw,
offset in integer:=1,
nth in integer:=1)
return integer;
对BLOB的查询需要转换成RAW(二进制)表达方式
不需要在把函数也执行一遍吗?我是想先在SQLPLUS中试一下