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

On Sun, 14 Apr 2002 22:50:23 +0100, "George Weer" <RubberDucky703_at_hotmail.com> wrote:

Oracle in 9i follows the ANSI standard and you can use outer join keywords. I hate that + sign!

>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 - 18:30:37 CDT