ITSE 2354 - ADVANCED ORACLE PL/SQL
Advanced use of Oracle SQL. Topics include hierarchical queries, set based queries, correlated subqueries, scripting, and scripting generation.
Upon 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
Grade Basis: L
Credit Hours: 3
Lecture hours: 32.0
Lab hours: 32.0