Dynamic SQL and Metadata

This course is included in our On-demand training solution.

Overview

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 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?