|
Provided by: Serebra Learning Corporation Explicit Cursors and Exception Errors |
 |
Training
Provided by Serebra Learning Corporation
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled Database administrators, application developers, and database operators
|
|
||||||||
Explicit Cursors and Exception Errors
Audience
Database administrators, application developers, and database operators
Topics
Objectives
- Explicit Cursors and Exception Errors
- use explicit cursors to retrieve data.
- process data using records, cursor attributes, and cursor FOR loops.
- use parameters to make cursors reusable in a given scenario.
- use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows.
- use an explicit cursor to retrieve and update data.
- outline how each of the PL/SQL exception types are raised and handled.
- trap predefined and non-predefined exceptions in PL/SQL.
- trap user-defined exceptions and identify error codes and messages.
- use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL.
- handle exceptions in PL/SQL.
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
