SELECT (SELECT listagg (to_char (RENWU), '& lt; br> ') WITHIN GROUP (order by ROWNUM)
The FROM (SELECT (ROWNUM | | ', '| | RENWU) RENWU
The FROM BO_EU_JSGC_XMZB_XZJH BEJXX
WHERE BEJX. BINDID=BEJXX. NEXT_WEEK BINDID)),
(SELECT listagg (to_char (RENWU), '& lt; br> ') WITHIN GROUP (order by ROWNUM)
The FROM (SELECT (ROWNUM | | ', '| | RENWU) RENWU
The FROM BO_EU_JSGC_XMZB_WCQK BEJXX
WHERE BEJX. BINDID=BEJXX. LAST_WEEK BINDID)),
(SELECT listagg (to_char (WANCHENGQINGKUANG), '& lt; br> ') WITHIN GROUP (order by ROWNUM)
The FROM (SELECT (ROWNUM | | ', '| | WANCHENGQINGKUANG) WANCHENGQINGKUANG
The FROM BO_EU_JSGC_XMZB_WCQK BEJXX
WHERE BEJX. BINDID=BEJXX. LAST_WEEK_QK BINDID)),
(SELECT listagg (to_char (PCQK), '& lt; br> ') WITHIN GROUP (order by ROWNUM)
The FROM (SELECT (ROWNUM | | ', '| | PCQK) PCQK
The FROM (SELECT (JJFA WENTI | | ', '| | JJFA. ZONGTIMUBIAO) PCQK
The FROM BO_EU_JSGC_XMZB_JJFA JJFA
WHERE BEJX. BINDID=JJFA. BINDID
Union all
SELECT (BGPC. MINGCHENG | | ', '| | BGPC. MIAOSHU) PCQK
The FROM BO_EU_JSGC_XMZB_BGPC BGPC
WHERE BEJX. BINDID=BGPC. PCQK_YY BINDID)))
The FROM BO_EU_JSGC_XMZB BEJX;

CodePudding user response:

CodePudding user response:

The execution plan is wrong, SQL syntax impassability itself is unable to perform

CodePudding user response:

refer to the second floor riven2011 response:

the execution plan is wrong, SQL syntax impassability itself is unable to perform

The SQL not wrong ah

CodePudding user response:

Don't fill the data directly run?

CodePudding user response:

reference 4 floor nayi_224 response:

didn't run the irrigation data directly?

There are data, running after stitching is right

CodePudding user response:

reference hu249523215 reply: 3/f

Quote: refer to the second floor riven2011 response:

the execution plan is wrong, SQL syntax itself impassability is unable to perform

The SQL not wrong ah

You are using is 10 g version, this is not in conformity with the do not conform to the ANSI standard, belongs to the BUG