急:一个把CLOB字段插入表....
insert into aa(title,lanmu)select distinct a.title,b.clumn_name from a, b,c where a.articleid=c.articleid and b.clumn_id=c.clumn_id;
其中b.clumn_name ,是CLOB类型
报ORA-00932: inconsistent datatypes: expected - got CLOB错
[解决办法]
去掉DISTINCT
