Link to home
Start Free TrialLog in
Avatar of ktylerconk
ktylerconkFlag for United States of America

asked on

SQL Where statement - column_name(+)

I have inherited some old code and am wondering why the (+) was coded in this statement, as I have never seen it used before, and can find no reference to it on the internet.


Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

It is the old OUTER JOIN Oracle syntax.
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ktylerconk


Thank you Kent!!
Here is the doc link that talks about it:

I'm on fence with Kdo's post.  I've been Oracle and only Oracle for so long, I've still not quite mastered the ANSI join syntax and find it confusing (but I also haven't taken the time to figure it out).
Thank you for the great article slightwv!  It should help me!