ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB

出错语句如下所示：

create table fetch_bank_concat_ethan as select fid,count(*) bb_num,cast(WMSYS.WM_CONCAT( FBANK_NAME||'_'||FBANK_TYPE||'_'||FCARD_TAIL||'_'||FAREA||'_'||FCITY||'_'||FBANKID||'_'||FSTATE||'_'||FCURTYPE||'_'||FPRIMARY_FLAG||'_'||FLOGIN_IP||'_'||FMEMO||'_'||to_number(to_char(FMODIFY_TIME,'yyyymmddhhmiss'))||'_'||to_number(to_char(fcreate_time,'yyyymmddhhmiss'))) as clob) BB_CONCAT from user_fetch_bank_ethan group by fid;

这是由于clob不支持一些操作引起的：

列出lob类型不支持的sql语句

 

不支持的语句不支持的用法例子SELECT DISTINCT

SELECT DISTINCT clobCol from...

SELECT clause           

ORDER BY

SELECT... ORDER BY clobCol

SELECT clause           

GROUP BY

SELECT avg(num) FROM...

GROUP BY clobCol

UNION, INTERSECT, MINUS           

(Note that UNION ALL works for LOBs.)

SELECT clobCol1 from tab1 UNION SELECT clobCol2 from tab2;

Join queries

SELECT... FROM... WHERE tab1.clobCol = tab2.clobCol

Index columns

CREATE INDEX clobIndx ON tab(clobCol)...