ITSE 2354 - Advanced Oracle PL/SQL

    Credit hours
    3
    Prerequisite
    ITSE 1345 or instructor permission.
    Texas Core Curriculum
    Not on the Midland College core curriculum list
    Description
    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 execute remote procedure calls; create a package to group together variables, cursors, exceptions, procedures, and functions; and invoke a package constraint.