SQL> desc bb; Name Type Nullable Default Comments ---- ----------- -------- ------- -------- A VARCHAR2(2) Y B VARCHAR2(2) Y C CLOB Y D BLOB Y SQL> select * from bb;A B C D -- -- - -SQL> insert into bb (d) values ('123456');1 row insertedSQL> select dbms_lob.substr(d) from bb;DBMS_LOB.SUBSTR(D) -------------------------------------------------------------------------------- 123456SQL> select 1 from bb where dbms_lob.instr(d,'34',1,1)>1; 1 ---------- 1 要看blob所存的内容是什么. function insstr(lob_loc in blob, pattern in raw, offset in integer:=1, nth in integer:=1) return integer;
Name Type Nullable Default Comments
---- ----------- -------- ------- --------
A VARCHAR2(2) Y
B VARCHAR2(2) Y
C CLOB Y
D BLOB Y SQL> select * from bb;A B C D
-- -- - -SQL> insert into bb (d) values ('123456');1 row insertedSQL> select dbms_lob.substr(d) from bb;DBMS_LOB.SUBSTR(D)
--------------------------------------------------------------------------------
123456SQL> select 1 from bb where dbms_lob.instr(d,'34',1,1)>1; 1
----------
1
要看blob所存的内容是什么.
function insstr(lob_loc in blob,
pattern in raw,
offset in integer:=1,
nth in integer:=1)
return integer;