SQL> desc bb Name Type Nullable Default Comments ---- ----------- -------- ------- -------- A VARCHAR2(2) Y B VARCHAR2(2) Y C CLOB Y D BLOB Y SQL> select dbms_lob.substr(d) from bb;DBMS_LOB.SUBSTR(D) -------------------------------------------------------------------------------- 123456SQL> select dbms_lob.substr(d) from bb where dbms_lob.instr(d,'34')>1;DBMS_LOB.SUBSTR(D) -------------------------------------------------------------------------------- 123456
Name Type Nullable Default Comments
---- ----------- -------- ------- --------
A VARCHAR2(2) Y
B VARCHAR2(2) Y
C CLOB Y
D BLOB Y SQL> select dbms_lob.substr(d) from bb;DBMS_LOB.SUBSTR(D)
--------------------------------------------------------------------------------
123456SQL> select dbms_lob.substr(d) from bb where dbms_lob.instr(d,'34')>1;DBMS_LOB.SUBSTR(D)
--------------------------------------------------------------------------------
123456