ORA-00932: inconsistent datatypes: expected - got CLOB
摘要:
SQL> SELECT DISTINCT D.SQL_ID, D.SQL_FULLTEXT, D.SQL_TEXT 2 FROM V$SQL D 3 WHERE D.SQL_ID = 'fsuzhxtaw402x';ORA-00932: inconsistent datatypes: expected - got CLOB-- 由于SQL_FULLTEXT是CLOB类型,可能是oracle不支持对CLOB类型的distinct 去掉distinct后查询正常SQL> SELECT D.SQL_ID, D.SQL_FULLTEXT, D.SQL_TEXT 2 FROM 阅读全文
posted @ 2012-02-28 16:47 皮狼 阅读(10519) 评论(0) 推荐(0) 编辑