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