Home » SQL & PL/SQL » SQL & PL/SQL » Condition ending with (+) ? What is mean?
Condition ending with (+) ? What is mean? [message #244189] Mon, 11 June 2007 21:53 Go to next message
Messages: 1
Registered: June 2007
Junior Member
Could anyone know what is the meaning when the PL/SQL condtion end with (+) ?
For example:
Select * From Table1, Table2, Table3
Where Table1.a=Table2.a(+) and Table1.b=Table2.b(+) and Table1.c=Table3.c(+)

What is mean? If I want to convert it to sql, how to do it?
please help..

Thank you

[Updated on: Mon, 11 June 2007 22:20]

Report message to a moderator

Re: Condition ending with (+) ? What is mean? [message #244208 is a reply to message #244189] Tue, 12 June 2007 00:10 Go to previous message
Messages: 1848
Registered: November 2006
Senior Member
It means Oracle OUTER JOIN operator.
As this is part of Oracle SQL you can use it there as well.
Optionally you may rewrite it to LEFT OUTER JOINs as shown in examples.
Previous Topic: v$session_longops
Next Topic: function help
Goto Forum:

Current Time: Fri Aug 18 20:37:25 CDT 2017

Total time taken to generate the page: 0.23739 seconds