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: What does the (+) operator mean in sql queries?

Re: What does the (+) operator mean in sql queries?

From: George Weer <RubberDucky703_at_hotmail.com>
Date: Sun, 14 Apr 2002 22:50:23 +0100
Message-ID: <a9ctii$226rq$1@ID-116287.news.dfncis.de>


thanks

"PMG" <stilvi_at_hotmail.com> wrote in message news:a9csk2$gli$1_at_ulysses.noc.ntua.gr...
> OUTER JOIN
>
> "George Weer" <RubberDucky703_at_hotmail.com> wrote in message
> news:a9cs7u$272i5$1_at_ID-116287.news.dfncis.de...
> > Hello,
> >
> > I have a query which is this:
> >
> > SELECT supplier.id
> > FROM supplier, order
> > WHERE supplier.id = order.suppid (+)
> > AND order.suppid IS NULL;
> >
> > I'm curious as to what the (+) is for in the query. I'm new in a job
> which
> > uses alot of oracle and i'm just starting.
> >
> >
> >
> > --
> > Thanks lots
> >
> >
> > Sorry for C/P not sure where to post.
> >
> >
>
>
Received on Sun Apr 14 2002 - 16:50:23 CDT

Original text of this message

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