<div>
It is the old OUTER JOIN Oracle syntax.
</div>


<div>
Here is the doc link that talks about it:<br />
<br />
<a href="http://docs.oracle.com/cd/E11882_01/server.112/e26088/queries006.htm#SQLRF52354" rel="ugc nofollow">http://docs.oracle.com/cd/E11882_01/server.112/e26088/queries006.htm#SQLRF52354</a><br />
<br />
I'm on fence with Kdo's post. &nbsp;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).
</div>


Here is the doc link that talks about it:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/queries006.htm#SQLRF52354 [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).

<div>
Thank you for the great article slightwv! &nbsp;It should help me!
</div>


Thank you for the great article slightwv!  It should help me!

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
WHERE &nbsp; &nbsp; &nbsp; &nbsp;c.CASE_NUMBER = cz.CASE_NUMBER(+)<br />
<br />
Thanks
</div>
</div>


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

SQL Where statement - column_name(+)

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.