pl/sql (+) function RSS

• • Reply
  

  -_-

  Member

  376 Points

  1046 Posts

  pl/sql (+) function

  Jul 10, 2012 07:47 AM|LINK

  i would like to ask about what is the function of (+) in pl/sql?

  if i have table a and b and joining by id.

  select * from table_a,table_b where a.id=b.id(+)

• • Reply
  

  adeelehsan

  All-Star

  18593 Points

  2789 Posts

  Re: pl/sql (+) function

  Jul 10, 2012 08:22 AM|LINK

  It is used for Outer Join in Oracle

  --Edited--

  See the following link for more info:

  http://docs.oracle.com/cd/B19306_01/server.102/b14200/queries006.htm#sthref3175

  Please Mark As Answer if it helped.
  

  ---

  
  MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
  Microsoft Community Contributor Award 2011
  • Edited by adeelehsan on Jul 10, 2012 08:23 AM
  • Marked as answer by Ming Xu - MSFT on Jul 19, 2012 02:23 PM