Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL

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

Overview

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.

Target Audience

Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites

The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration

100 min.

Course Objectives

Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL

  • recognize the steps for creating user-defined PL/SQL records and records with the %ROWTYPE attribute.
  • recognize the steps for creating an INDEX BY table and table of records, and identify the uses of nested tables and VARRAYs.
  • define, create, and use INDEX BY tables and a PL/SQL record in a given scenario.
  • identify the steps for declaring and controlling explicit cursors, and for writing FOR loops to fetch data from them.
  • recognize the steps for declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?