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 -> Re: LEFT and RIGHT OUTER JOINs in Oracle SQL?

Re: LEFT and RIGHT OUTER JOINs in Oracle SQL?

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sun, 9 Dec 2001 09:57:52 -0600
Message-ID: <u172g2kske7f25@corp.supernews.com>


By the way, The Left and RIGHT OUTER JOIN clause is available in Oracle 9i.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Roger Abercombie" <rab_at_spambegone.be> wrote in message news:3c1361be_4_at_news2.prserv.net...
> Hello,
>
> I'm a newcomer to the Oracle environment.
>
> A noticeable absense in Oracle SQL is the lack of the SQL-standard
> LEFT and RIGHT OUTER JOIN clauses (unless I misread the
> documentation :-) Could anybody offer any 'standard' or
> cookbook syntax for replacing these clauses when developing
> for Oracle?
>
> Thanks!
>
>
>
>
>
Received on Sun Dec 09 2001 - 09:57:52 CST

Original text of this message

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