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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Default Question (Resent)

Re: SQL Default Question (Resent)

From: <campbell_r_at_sbcglobal.net>
Date: Tue, 11 Mar 2003 19:59:18 GMT
Message-ID: <qerba.352$Wu3.230@newssvr16.news.prodigy.com>


Total := NVL(Num1,0) + NVL(Num2,0);

"abc" <abc_at_abc.com.au> wrote in message
news:b3hcvh$rrm$1_at_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 Mar 11 2003 - 13:59:18 CST

Original text of this message

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