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 is (+) in PL/SQL means ?

Re: What is (+) in PL/SQL means ?

From: Bricklen <bricklenREMOVETHIS_at_shaw.ca>
Date: Sun, 17 Feb 2002 22:10:00 GMT
Message-ID: <3C7029C6.862A6142@shaw.ca>


look up outer joins.

"ianmcq_at_homex.com" wrote:
>
> Hi all,
> I have a stored procedure written by someone else. Some select
> statements in this SP the where clause contains (+), e.g.
> select s1.service_id, s2.service_id
> from services s1,
> services s2,
> service_profile sp
> where s1.service_plan = parBillCode
> and s1.service_id = sp.service_id (+)
> and sp.category (+) = 'PLAN_AAA'
> and sp.parameter = s2.service_plan (+);
>
> I can't search any reference because search engine seems to ignore (+)
> characters...
> (I use google search, type in ("(+)" PL/SQL) in the textbox, but the
> result only contains "PL/SQL"....)
Received on Sun Feb 17 2002 - 16:10:00 CST

Original text of this message

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