Dec 12, 2024  
2016-2017 Midland College Catalog 
    
2016-2017 Midland College Catalog [ARCHIVED CATALOG]

Add to My Personal Catalog (opens a new window)

ITSE 2354 - Advanced Oracle PL/SQL


3 Hours (3-1)
A continuation of Oracle SQL. Topics include hierarchical queries, set based queries, correlated subqueries, scripting, and scripting generation. The student will retrieve data including SET operators, correlated subqueries, and hierarchical queries; write SQL scripts that generate other SQL scripts; and write and execute a script that generates a script of drop table commands and insert commands; create procedures and functions; create a package to group together variables, cursors, exceptions, procedures, and functions; and invoke a package constraint. Prerequisites: ITSE 1345  or instructor permission.


Click here for course scheduling information.



Add to My Personal Catalog (opens a new window)