有2个表:
table a有两个字段:
question (clob)
answer (clob)table b有两个字段:
question (clob)
answer (clob)
select *
from a
where question in (select question from b)得到的错误:ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB
clob到底要怎么用才对?如果是vchar的话就没问题了。
table a有两个字段:
question (clob)
answer (clob)table b有两个字段:
question (clob)
answer (clob)
select *
from a
where question in (select question from b)得到的错误:ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB
clob到底要怎么用才对?如果是vchar的话就没问题了。
clob还真没有这么用过啊,关注下!
from a,b
where a.question = b.question
这句sql语句也有错误。两个clob字段不能判断相等吗?
from a,b
where dbms_lob.compare(a.question,b.question)=0;
我把数据类型换成vchar2了,这样很快。