SELECT (SELECT listagg(to_char(RENWU), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || RENWU) RENWU
FROM BO_EU_JSGC_XMZB_XZJH BEJXX
WHERE BEJX.BINDID = BEJXX.BINDID)) NEXT_WEEK,
(SELECT listagg(to_char(RENWU), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || RENWU) RENWU
FROM BO_EU_JSGC_XMZB_WCQK BEJXX
WHERE BEJX.BINDID = BEJXX.BINDID)) LAST_WEEK,
(SELECT listagg(to_char(WANCHENGQINGKUANG), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || WANCHENGQINGKUANG) WANCHENGQINGKUANG
FROM BO_EU_JSGC_XMZB_WCQK BEJXX
WHERE BEJX.BINDID = BEJXX.BINDID)) LAST_WEEK_QK,
(SELECT listagg(to_char(PCQK), '<br>') WITHIN GROUP(order by ROWNUM)
FROM (SELECT (ROWNUM || '、' || PCQK) PCQK
FROM (SELECT (JJFA.WENTI || ',' || JJFA.ZONGTIMUBIAO) PCQK
FROM BO_EU_JSGC_XMZB_JJFA JJFA
WHERE BEJX.BINDID = JJFA.BINDID
union all
SELECT (BGPC.MINGCHENG || ',' || BGPC.MIAOSHU) PCQK
FROM BO_EU_JSGC_XMZB_BGPC BGPC
WHERE BEJX.BINDID = BGPC.BINDID))) PCQK_YY
FROM BO_EU_JSGC_XMZB BEJX;
uj5u.com熱心網友回復：
uj5u.com熱心網友回復：
這個執行計劃是錯的，sql本身語法不通是沒法執行的uj5u.com熱心網友回復：
這個sql沒錯誤呀
uj5u.com熱心網友回復：
沒灌資料直接跑的？uj5u.com熱心網友回復：
有資料，運行后拼接也是正確的
uj5u.com熱心網友回復：
你用的是10G版本，這個不符合不符合ANSI標準，屬于BUG
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/8485.html
標籤：基礎和管理