429: Aces in the Hole: Learning Advanced SQL Techniques from OTN Forum Pros
Greg Pike , PIOCON Technologies    Biography

Objectives: Understand the value of the OTN SQL and PL/SQL community forum as a valuable learning resource.
Appreciate the myriad of solutions available for solving complex problems with SQL and PL/SQL.
Evaluate the efficiency of differing SQL solutions.
Abstract: Although seasoned professionals understand the benefits of solving business problems with efficient queries or PL/SQL, the volunteer Oracle experts and Ace contributors on OTNís SQL and PL/SQL discussion forums raise the query writing bar to an entirely new level. Oracle professionals at any skill level will find this forum packed with a treasure chest of tips, tricks and techniques. With over 50,000 topics and 300,000 posts, itís the mother lode of SQL and PL/SQL education from recognized experts worldwide.

In this session, the powerful techniques of advanced query authoring are explored by reviewing real-world forum topics and the unique solutions posted by gurus. The resident experts from the OTN forums solve problems using a combination of analytic functions (PARTITION BY), hierarchical query (CONNECT BY), collection functions (COLLECT ), XML functions/operators (SYS_XMLGEN, and XMLSEQUENCE), Pipelined Functions, the MODEL clause and more.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Development
Date: Tuesday, April 15, 2008
Time: 9:45 AM - 10:45 AM