Dynamic SQL and Metadata


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


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.

    • Course Number:
    218842_eng