ITSE 2354 - ADVANCED ORACLE PL/SQL

A continuation of Oracle SQL. Topics include hierarchical queries, set based queries, correlated subqueries, scripting, and scripting generation. 32 lecture hours32 laboratory hours

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

Prerequisites: