Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What does the (+) operator mean in sql queries?
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