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

Its not an entirely unreasonable question (what does (+) mean) . However even though this is neither SQL92 syntax nor particularly intuitive I would have expected someone who knew about outer joins (ie anyone who has programmed seriously in SQL for more than a day or 2) to guess the meaning. But to a SQL newbie I would guess that this notation is completely opaque, and not easy to find in the documentation for the reasons cited.

Regards

Heinz

"Keld Nielsen" <keldnielsen_at_image.dk> wrote in message news:<9cWb8.15063$5L3.641730_at_news010.worldonline.dk>...
> 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 Mon Feb 18 2002 - 03:01:47 CST