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
135 Minutes

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.


    • Course Number: 218842_eng