Online Explicit Cursors eLearning
Explicit Cursors Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL

Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL Oracle
To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.
more...
Oracle Database 11g Using Data Types INDEX BY Tables and Cursors in PL SQL
Explicit Cursors and Exception Errors

Explicit Cursors and Exception Errors Oracle
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
more...
Oracle Database 11g Using Data Types INDEX BY Tables Cursors

Oracle Database 11g: Using Data Types, INDEX BY Tables & Cursors Oracle
To recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters.
more...
Oracle Database 10g PL SQL Fundamentals Part 1

...f loop statements.
Identify the syntax for controlling explicit cursors.
Identify the syntax for using cursor FOR loops.
Identify the syntax used to obtain status information about a cursor using explicit cursor attributes.
Identify the syntax of the FOR UPDATE clause.
Identify the syntax of the WHERE CURRENT OF clause.
Identify features of exceptions.
Identify guidelines
more...
Oracle SQL Tuning Tuning SQL and the Optimizer

... or an implicit cursor.
Identify the advantage of using explicit cursors.
Identify the advantages of using explicit cursors.
Identify the language that will process a given task in the minimum possible time.
Identify the methods used for maintaining a shared pool.
Identify the contents of a shared SQL area.
Sequence the steps performed in the Oracle Server for processing a SQL
more...
SQL and PL SQL PL SQL Basics

...es of LOB datatypes. Understand cursors, how to operate explicit cursors, work with explicit cursor attributes Use the advanced functionality of explicit cursors. Understand the basic concepts of exceptions, trap predefined, nonpredefined, and user-defined exceptions Understand how exceptions are propagated. C ontent Emphasis Skills-Based A udience Application Developers,
more...
From Serebra Learning Corporation
Explicit Cursors and Exception Errors
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
more...
Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations
The course is aimed at familiarizing the learner with the basic concepts of PL/SQL. It describes the different datatypes and variables available with PL/SQL. The course provides an overview of PL/SQL records and tables and explains how to access a database from PL/SQL. It also describes the steps to write conditional constructs and controlling structures in PL/SQL along with different types of
more...
