Dynamic SQL and Metadata

Overview/Description
To write dynamic SQL and use the DBMS_METADATA package

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
2.2

Lesson Objectives

Dynamic SQL and Metadata

identify the execution flow of SQL and distinguish between the PL/SQL statements used to support Native Dynamic SQL.

use EXECUTE IMMEDIATE to dynamically build DDL and DML statements.

write and execute dynamic SQL queries and PL/SQL blocks.

use the DBMS_SQL package to dynamically execute a DML statement.

write dynamic SQL for a given scenario.

use the DBMS_METADATA programming interface to generate DDL from metadata.

generate DDL from metadata using the DBMS_METADATA browsing interface.

generate DDL from metadata using the DBMS_METADATA package.