Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL Default Question (Resent)
Hi All,
I have a PL/SQL to do following calculation:
Total = NUM1 + NUM2;
SELECT a INTO NUM1 FROM T1;
SELECT b INTO NUM2 FROM T2;
As b has no return row therefore NUM2 is undefined. Total as a result is also undefined (PL/SQL crashed with "No defined value ...")
Is there any way to return b as ZERO if no row returned ???
I have tried
SELECT NVL(
(SELECT b INTO NUM2 FROM T2), 0) FROM DUAL;
But PL/SQL did not allow me to use SELECT ...(SELECT !
SELECT NVL(NUM2,0) FROM DUAL doesn't work. Received on Tue Feb 25 2003 - 21:40:37 CST