443: Dynamic SQL: Solving Real-World Problems in Real Time
Michael Rosenblum , Dulcian, Inc.    Biography

Objectives: Understand the functionality provided by Dynamic SQL
Understand the limitations, dangers, and side-effects of dynamic SQL
Learn how dynamic SQL can be used to solve real problems
Abstract: To correctly use the advanced features in any programming language, it is not enough to just know the syntax. You must really understand what is going on “under the hood. Although the entire implementation of Dynamic SQL consists of one command (EXECUTE IMMEDIATE), one variation of the cursor (OPEN...FOR...), and one package (DBMS_SQL), the number of possibilities and potential side-effects is amazing.

In addition to covering the core functionality of Dynamic SQL this session covers some of the less obvious issues that arise while using dynamic SQL: defining required privileges, preventing code injections, targeting performance tuning efforts, understanding resource utilization, handling object dependencies, etc.

Case studies will demonstrate when, why, and how to use Dynamic SQL in real-world situations in conjunction with other advanced features. Version 11g additions such as conversion between REF CURSORs and DBMS_SQL cursors will also be covered.

Audiernce Focus: Developers
Expertise: Intermediate
Track: Development
Date: Monday, April 14, 2008
Time: 9:15 AM - 11:30 AM