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