[20150707]ORA-00932: inconsistent datatypes: expected - got CLOB.txt

--自己写一个通过sql_id查看sql语句的脚本：

column sqltext format a200

select sql_id,replace(sql_fulltext,chr(13),'') sqltext  from v$sql where  sql_id = '&&1' and rownumunion select sql_id,replace(sql_text,chr(13),'') sqltext  from dba_hist_sqltext where  sql_id = '&&1' and rownum

--出现如下错误：

              * ERROR at line 1: ORA-00932: inconsistent datatypes: expected - got CLOB

--修改如下ok：

$ cat sqlid.sql

column sql_fulltext format a160 column sqltext format a200

select sql_id,to_char(replace(sql_fulltext,chr(13),'')) sqltext  from v$sql where  sql_id = '&&1' and rownumunion

select sql_id,to_char(replace(sql_text,chr(13),'')) sqltext  from dba_hist_sqltext where  sql_id = '&&1' and rownum