| |
Apr 30, 2026
|
|
|
|
|
ITSE 2354 - Advanced Oracle PL/SQL
Advanced use of Oracle SQL. Topics include hierarchical queries, set based queries, correlated subqueries, scripting, and scripting generation.
Learning Outcomes: 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.
Credit Hour(s): 3
Lecture Hour(s): 32
Lab Hour(s): 32
Prerequisite(s): ITSE 1345 Introduction to Oracle SQL
Add to Portfolio (opens a new window)
|
|
