6 hours

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

To provide the student with a detailed understanding of modular programming in PL/SQL using stored procedures and functions

After this course the student should be able to:
1. describe the user-defined composite data-structures available in PL/SQL
2. create, call, and pass parameters to a PL/SQL procedure

4 hours

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

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

After this course the student should be able to:
1. create a PL/SQL package to include functions and procedures
2. describe how overloading is implemented and how the contents of the standard package are used