Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What does the (+) operator mean in sql queries?

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

From: George Weer <RubberDucky703_at_hotmail.com>
Date: Sun, 14 Apr 2002 22:27:38 +0100
Message-ID: <a9cs7u$272i5$1@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:27:38 CDT

Original text of this message

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