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 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后查询正常