2016-2017 Undergraduate Catalog 
    
    Mar 28, 2024  
2016-2017 Undergraduate Catalog [ARCHIVED CATALOG]

MIS 451 - Programming with Advanced PL/SQL


Credit Hours: 3
Lecture Hours: 3
Lab Hours: 0

This course covers advanced PL/SQL concepts. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms; create reports and data management applications; create anonymous PL/SQL blocks; work with stored procedures and functions; declare variables; trap exceptions; and declare and control cursors. In addition, students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. They also learn to manage object dependencies and the recompilation of invalid objects. This course also describes the characteristics and techniques of the manipulation of large objects. Students are introduced to the uses of some of the Oracle-supplied packages. This is one of three Oracle certification training courses.
Prerequisite: MIS 321  or MIS 450 


Please click here for Book Information