The new ANSI format for joins in Oracle 9i may appear alien at first, but they have the potential to become part of a DBA's arsenal for clarifying SQL and PL/SQL code. This article discusses the new join formats including NATIVE, CROSS, and OUTER and includes examples for review and comparison to the "traditional" join mechanisms.

This story continues at http://www.databasejournal.com/featu...le.php/2209301