[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 rownum<=1
union
select sql_id,replace(sql_text,chr(13),'') sqltext from dba_hist_sqltext where sql_id = '&&1' and rownum<=1;

--出现如下错误：
*
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 rownum<=1
union
select sql_id,to_char(replace(sql_text,chr(13),'')) sqltext from dba_hist_sqltext where sql_id = '&&1' and rownum<=1;

ITPub博客

[20150707]ORA-00932.txt

最新文章