Explicit Cursors and Exception Errors

This course is included in our On-demand training solution.

Overview

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

Target Audience

Database administrators, application developers, and database operators

Prerequisites

Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration

185 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?