系统环境:
1、数据库:
Oracle 8i R3 (8.1.7) for NT 企业版
说明:
CLOB字段可以select,但select时不可以使用where
SQL create table a(a clob);
SQL insert into a values('1234');
SQL insert into a values('5648');
SQL select *from a;
1234
5648
SQL select * from a where a like '%12%';
select * from a where a like '%12%'
*
ERROR 位于第 1 行:
ORA-00932: 数据类型不一致
SQL SELECT * FROM A WHERE dbms_lob.instr(a.a,'12',1,1)0;
1234
SQL SELECT * FROM A WHERE dbms_lob.instr(a.a,'5',1,1)0;
5648