NVL not working in Cursor Subquery [message #673958] |
Wed, 19 December 2018 13:24 |
|
vharish006
Messages: 70 Registered: August 2015 Location: Chicago
|
Member |
|
|
Hi All,
There is no record for the below mentioned Client_Invoice_ID in PQINF.XXPQ_IP_INVOICE_CHARGES IPA table.So we want to replace 0 when no value exists.
Below query gives 0 as required but when using the same query in Cursor Subquery it is giving null value. what Can I do
SELECT NVL(IPA.TOTAL_AMOUNT,0) AMODISC
FROM PQINF.XXPQ_IP_INVOICE_CHARGES IPA,
PQINF.XXPQ_IP_INVOICE_HEADER HDR
WHERE IPA.CLIENT_INVOICE_ID IS NULL
AND HDR.CLIENT_INVOICE_ID='EBS-2349970'
|
|
|
|
|
|
|