Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Default Question (Resent)

SQL Default Question (Resent)

From: abc <abc_at_abc.com.au>
Date: Wed, 26 Feb 2003 14:40:37 +1100
Message-ID: <b3hcvh$rrm$1@mws-stat-syd.cdn.telstra.com.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US