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

incredible, I begin to understand why some people reply the way they do !

I personally do not have much experience with inner/outher joins, but how come
that I know it's such a creature ?

"ianmcq_at_homex.com" <Ian McQueen> wrote in message news:j4907u8hh3f4k8qafr9rdshikp5nlmkvcm_at_4ax.com...
> 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:25:56 CST