|
|
|
Apr 25, 2024
|
|
2019-2020 Undergraduate Catalog [ARCHIVED CATALOG]
|
ISBA 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: ISBA 321 or ISBA 450
Please click here for Book Information
|
|
|
