在使用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%';
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%';
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%';
SELECT '其中201卡:',SUM(RATE_AMOUNT)
FROM BILL.T_NOSI_PRERATED_USAGE_EVENTS
WHERE LATN_ID=634 AND CREATE_CYCLE_SEQ=200612 AND CALLING_NUMBER LIKE '201%';
SELECT '其中莱钢:',SUM(RATE_AMOUNT)
FROM BILL.T_PRERATED_USAGE_EVENTS_200612
WHERE LATN_ID=634
AND CALLING_NUMBER LIKE '682%';