Re: A (+) in the where clause

In article 1521_at_grivel.une.edu.au, rpaulo_at_metz.une.edu.au (Reynaldo Paulo) writes:
-->Does anyone out there know what the (+) in the following
-->statement means?
-->
-->
-->select <something>
--> into <avariable>
--> from <atable>
--> where atable.field (+) = <somevalue>

A (+) in the where predicate indicates that it is an outer join. i.e. join to that field and include the rows where that field are NULL values.

---

*****************************************************************************
*  David Crowson        *  "It's a small world but a damn big planet!"      *
*  DBA (Oracle V4,5,6,7)* The views expressed here are of my own volition   *
*  Amoco Exploration    * and do not necessarily represent that of my       *
*  (UK) Ltd             * employers , nor are these views worth the paper   *
*  Ealing, London       * upon which they are written, nor do I make much   *
*  dcrowson_at_amoco.com   * sense to anyone including myself.                 *
*************************Fiat justitia,ruat coelum.**************************