OraFAQ Forum: SQL & PL/SQL » what does table.column = table.column(+) refer to

Home » SQL & PL/SQL » SQL & PL/SQL » what does table.column = table.column(+) refer to

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what does table.column = table.column(+) refer to [message #618594]

Mon, 14 July 2014 03:09

stahorse
Messages: 1
Registered: July 2014

Junior Member

Hi

I'm a SQL Developer and recently on PL\SQL project, so I have this situation;

SELECT UPLN.PLNNM
,UMBR.MBRID
FROM ebl2ulif.umbr,
ebl2ulif.upln
WHERE upln.plnid = umbr.plnid(+)

I would like to know, does this "umbr.plnid(+)" refer to Left Join or Right, or what does it refer to.

Thanks

Report message to a moderator

Re: what does table.column = table.column(+) refer to [message #618599 is a reply to message #618594]

Mon, 14 July 2014 03:40

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

upln LEFT OUTER JOIN umbr
ON upln.plnid = umbr.plnid

Your example uses the old Oracle join syntax, and I converted it into ANSI syntax. Oracle conforms with ANSI syntax since 9i. It is strongly recommended to use the ANSI syntax over the old historic method.

Edit : added a statement to explain the significance of both syntax

[Updated on: Mon, 14 July 2014 03:53]

Report message to a moderator

Re: what does table.column = table.column(+) refer to [message #618602 is a reply to message #618599]

Mon, 14 July 2014 03:51

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

(+) goes next to the columns of the optional table. ie the one where matching data doesn't have to be found.
LEFT and RIGHT refer to the mandatory table.

Report message to a moderator

Previous Topic:	Result as per Double Outer Join ?
Next Topic:	Method to take table backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 03:02:42 CDT 2024