[20150707]ORA-00932.txt

[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