SELECT nvl((SELECT orgid FROM tbcs.ar_bank_task t WHERE t.bankseqno='270000120200116001202011'),'') AS orgid FROM dual UNION ALL
SELECT nvl((SELECT orgid FROM tbcs.ar_bank_task t WHERE t.bankseqno='270000120200116001202011'),'') AS orgid FROM dual
重点是(SELECT orgid FROM tbcs.ar_bank_task t WHERE t.bankseqno='270000120200116001202011')的括号,不加括号会报错。
nvl是oracle数据的函数,mysql对应的函数为isnull。