NVL not working in Cursor Subquery [message #673958] |
Wed, 19 December 2018 13:24 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/ea38da6eb1e7d92665c21616326587d9?s=64&d=mm&r=g) |
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'
|
|
|
|
|
|
|