SQL 查询记录为空时补空行

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。