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)...