|
Provided by: Serebra Learning Corporation Dynamic SQL and Metadata |
 |
Training
Provided by Serebra Learning Corporation
To write dynamic SQL and use the DBMS_METADATA package Database administrators, application developers, and database operators
|
|
||||||||
Dynamic SQL and Metadata
Audience
Database administrators, application developers, and database operators
Topics
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.
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
