在使用PL/SQL查询时,可将多条查询语句一起输入,但输出结果在每个命令行的后面,可以将结果放在一起吗?
如:
SELECT '凈收入: ',SUM(TOTAL_DUE_AMOUNT)
FROM BILL.T_BILL_BALANCE_DETAIL_200612
WHERE LATN_ID=634 AND CHARGE_ID IN (341110,341120) AND STATUS NOT LIKE '9% ';
SELECT '其中168收入: ',SUM(TOTAL_DUE_AMOUNT)
FROM BILL.T_BILL_BALANCE_DETAIL_200612
WHERE LATN_ID=634 AND CHARGE_ID IN (341120) AND STATUS NOT LIKE '9% ';
------解决方案--------------------
SELECT '凈收入: ',SUM(TOTAL_DUE_AMOUNT)
FROM BILL.T_BILL_BALANCE_DETAIL_200612
WHERE LATN_ID=634 AND CHARGE_ID IN (341110,341120) AND STATUS NOT LIKE '9% ';
union
SELECT '其中168收入: ',SUM(TOTAL_DUE_AMOUNT)
FROM BILL.T_BILL_BALANCE_DETAIL_200612
WHERE LATN_ID=634 AND CHARGE_ID IN (341120) AND STATUS NOT LIKE '9% ';