DA 263 - Oracle PL/SQL Programming II

Credit Hours: 3

The mastery of PL/SQL, a procedural language extension to SQL will be continued in this course. Students will learn more advanced PL/SQL concepts such as PL/SQL packages, dynamic SQL, database triggers used to execute code automatically, advanced data types such as user-defined record types, and multi-media file types and how to manage object dependencies. Oracle Application Express, a browser based development environment will be used for coding PL/SQL blocks.

Course Outcomes
Upon completion, the student will be able to:

build upon PL/SQL programming concepts learned in Oracle PL/SQL Programming I class;
create packages which are PL/SQL blocks stored in the database and called for repeated execution when needed;
demonstrate the understanding of the visibility of objects in packages and how to invoke subprograms in packages;
apply such advanced PL/SQL concepts as overloading and forward referencing;
construct and execute dynamic SQL statements at run time in PL/SQL;
create PL/SQL triggers to execute automatically when certain DML or DDL events take place;
define fields using complex data types such as user-defined record types and large object data types to store multi-media files; and
detect database object dependencies, the different types, and how to correct them when necessary.

Prerequisites: DA 262
F/S (S)