ITSE 2454 - Advanced Oracle PL/ SQL

Institution:

Midland College

Subject:

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 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. Prerequisite ITSE 1445.

Credits:

4.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.midland.edu

Phone Number:

(432) 685-4500

Regional Accreditation:

Southern Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.