Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What does the (+) operator mean in sql queries?
"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
news:ulmbo1bkl.fsf_at_rcn.com...
> On Sun, 14 Apr 2002, RubberDucky703_at_hotmail.com wrote:
>
> > How does the outer join work?
>
> CONSIDER:
>
> [ snipped ]
And to add to this excellent example:
Find me data that is _not_ in t2 but is in t1 - in other words, how can I find data that is missing in t2 quickly and efficiently?
SQL> select * from t1,t2 where t1.fld1 = t2.fld1 (+) and t2.fld1 IS
NULL;
FLD1 FLD1
---------- ----------
1 3
-- Pablo Sanchez, High-Performance Database Engineering mailto:pablo_at_hpdbe.com Available for short-term and long-term contractsReceived on Tue Apr 16 2002 - 10:43:29 CDT