Using Composite Data Types

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

Overview

To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records

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

120 min.

Course Objectives

Using Composite Data Types

  • identify the benefits associated with records and collections in PL/SQL.
  • create and populate a user-defined record in PL/SQL.
  • create a record using the %ROWTYPE attribute and use it to insert and update a row.
  • create a record and use it to update a table.
  • create and reference an INDEX BY table and table of records.
  • declare and initialize nested tables and VARRAYs.
  • create and reference a table in PL/SQL.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?