PL/SQL: Packages and Triggers

Overview/Description
To provide the student with a detailed understanding of PL/SQL packaged procedures and database triggers

Target Audience
Database administrators, system administrators, and application developers who are using PL/SQL version 2 for the first time, and experienced developers who are upgrading from a previous PL/SQL version or another 3GL programming language

Prerequisites
The course Relational Principles; the courses on SQL*Plus; and the courses PL/SQL: Fundamentals, PL/SQL: Exceptions and Scripts, and PL/SQL: Procedures and Functions

Expected Duration
4:00 Hours

Objectives:

PL/SQL: Packages and Triggers

  • To examine how a stored PL/SQL package can enhance application development and performance
  • To examine the creation of a sample PL/SQL package
  • To examine how a stored database trigger can be used to protect data integrity at table level
  • To examine the creation of a sample database trigger


    • Course Number: PLSPT