Profile

e-Catalog

Contact

Search

Cart

Oracle Introduction: PL/SQL Cursors and Exceptions

Audience

Trainee database administrators and application developers

Prerequisites

Familiarity with programming techniques would be an advantage

Course Aim

To explain the concept of a composite database, and to show how to use cursors and handle exceptions in PL/SQL

Learning Objectives

Explain PL/SQL records and tables. Manipulate explicit cursors. Use cursor FOR loops. Explain the different types of exceptions. Trap and handle exceptions.

Topics Covered

Composite datatypes - PL/SQL records - PL/SQL tables - Hands-on: Creating a PL/SQL table Explicit cursors - Controlling cursors - Cursor attributes - Advanced cursor usage - Hands-on: Creating a PL/SQL block Handling exceptions - Trapping Oracle server errors - User-defined exceptions - Hands-on: Creating and invoking exceptions