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

Home -> Community -> Mailing Lists -> Oracle-L -> Outer Join puzzle - How this works?

Outer Join puzzle - How this works?

From: <LBhat_at_LEVI.com>
Date: Wed, 07 Feb 2001 01:09:13 -0800
Message-ID: <F001.002AD3BB.20010206222621@fatcity.com>

Hi All,

I have the two following queries alongwith the results. Can anybody interpret the results (fourth sql) and let me know why it works like this
(fourth sql).

SQL> select * from a;

           NUM
-        - - - - - - 
                       1
                       2
                       3

        SQL>  select * from b;
                   NUM1        NUM2
-        - - - - - -         - - - - -
             1                                      << NUM2 is null in this
record
2       2
3       1

SQL>  select  NUM, NUM1, NUM2  from a, b
           Where nvl(num2,1) = 1 and num=num1(+);
           NUM1        NUM2         NUM3
-        - - - - - -         - - - - -        - - - - - -
1       1
                3                  3                1

SQL>  select  NUM, NUM1, NUM2  from a, b
           Where nvl(num2(+),1) = 1 and num=num1(+);
           NUM1        NUM2         NUM3
-        - - - - - -         - - - - -        - - - - - -
1       1
2        
3       3                 1


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: LBhat_at_LEVI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Feb 07 2001 - 03:09:13 CST

Original text of this message

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