Description
Advanced use of Oracle SQL. Topics include hierarchical queries, set based queries, correlated subqueries, scripting, and scripting generation.
Upon successful completion, students will be able to: retrieve data including SET operators, correlated subqueries, and hierarchical queries; write SQL scripts that execute remote procedure calls; create a package to group together variables, cursors, exceptions, procedures, and functions;
invoke a package constraint.
Prerequisite: ITSE 1345 Introduction to Oracle SQL
32 lecture hours + 32 laboratory hours.