420: To ANSI or not to ANSI
Rumpi Gravenstein , Amtrust Bank    Biography

Objectives: Familiarize all to ANSI Join Syntax
Convince all of the merits of ANSI join syntax
Convince all to use ANSI syntax
Abstract: With release 9i, in 2002, Oracle introduced support for the ANSI SQL join syntax. Many Oracle professionals didn't see much need for ANSI joins and thought of it just as an attempt to stay compliant with emerging RDBMS database standards. Further confounding the issue, the new syntax didn't add must have new features. That type of thinking misses the point entirely. Oracle professionals take note. Writing ANSI compliant SQL improves code clarity and reduces the number of errors in your SQL statements. This presentation will first review ANSI SQL join syntax and then discuss how best to use it and how not to use it. Finally, we will discuss why we believe that the additional clarity inherent in the ANSI syntax should make it a key element in your efforts to develop maintainable, error free SQL statements.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Development
Date: Wednesday, April 16, 2008
Time: 11:00 AM - 12:00 PM