Vi ste ovdje
Oracle Database 11g: Using Triggers and the PL/SQL Compiler
Overview/Description
To identify the steps for creating, managing, and using database triggers, and for using the new PL/SQL compiler, its initialization parameters, and its compile time warnings.
Target Audience
System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers.
Prerequisites
Previous programming experience and knowledge of SQL
Oracle Database 11g: Using Triggers and the PL/SQL Compiler
- identify the steps for creating and using database triggers.
- recognize the steps for enabling, disabling, testing, managing, and removing database triggers.
- identify the steps for creating and using compound, DDL, and event database triggers.
- create statement and row triggers, including a trigger for a business rule and a package with triggers that resolve a mutating table issue.
- recognize the benefits and capabilities of the PL/SQL compiler and its parameters.
- recognize the steps for using the PL/SQL compiler initialization parameters, compiling a procedure, and managing compiler warnings.
Trajanje:
2h
Šifra:
260275_eng