Webcast Series 3: Fast Track Your Oracle PL/SQL Expertise (Session 3)

Session 3: Dynamic SQL in Oracle PL/SQL

Dynamic SQL (construction, parsing and execution of SQL statements and PL/SQL blocks at runtime) has become a common and critical element of most modern applications. PL/SQL offers two distinct methods for dynamic SQL: native dynamic SQL (NDS) and DBMS_SQL. This webinar focuses primarily on the capabilities of native dynamic SQL: how to use EXECUTE IMMEDIATE to execute dynamic query, DML, and DDL statements. We will also go beyond the basics and delve into when to use DBMS_SQL (method 4 dynamic SQL), and new Oracle Database 11g features for dynamic SQL (most importantly, interoperability between DBMS_SQL and NDS. The session will last approximately two hours.

Register