出错语句如下所示:
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)... |