Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: simple query help
Alan Shein <alanshein_at_erols.com> wrote in message news:84t8hv$657$1_at_bob.news.rcn.net...
> Yes.
>
> a.dept(+) = b.dept
>
> or
>
> a.dept = b.dept(+)
>
> depending on what you want...
No.
You can not predicate which side is "larger".
And more, you can not assume A is a superset of B, nor B is a superset of A.
Take look at a quick example:
dept dude status
==== ==== ======
north, bob, i,
east, mary, a,
Received on Thu Jan 06 2000 - 09:29:02 CST
![]() |
![]() |