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.
WHERE c.CASE_NUMBER = cz.CASE_NUMBER(+)
Thanks
WHERE c.CASE_NUMBER = cz.CASE_NUMBER(+)
Thanks
Oracle DatabaseSQL
Last Comment
ktylerconk
It is the old OUTER JOIN Oracle syntax.
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
Thank you Kent!!
Here is the doc link that talks about it:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/queries006.htm#SQLRF52354
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).
http://docs.oracle.com/cd/E11882_01/server.112/e26088/queries006.htm#SQLRF52354
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).
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
Thank you for the great article slightwv! It should help me!