Composite Data Types Notes

·     PL/SQL Collections and Records

·     Collection Types

·     Associative Arrays

·     Declaring Associative Array Constants

·     NLS Parameter Values Affect Associative Arrays Indexed by String

·     Changing NLS Parameter Values After Populating Associative Arrays

·     Indexes of Data Types Other Than VARCHAR2

·     Passing Associative Arrays to Remote Databases

·     Appropriate Uses for Associative Arrays

·     Varrays (Variable-Size Arrays)

·     Appropriate Uses for Varrays

·     Nested Tables

·     Important Differences Between Nested Tables and Arrays

·     Appropriate Uses for Nested Tables

·     Collection Constructors

·     Qualified Expressions Overview

·     Assigning Values to Collection Variables

·     Data Type Compatibility

·     Assigning Null Values to Varray or Nested Table Variables

·     Assigning Set Operation Results to Nested Table Variables

·     Multidimensional Collections

·     Collection Comparisons

·     Comparing Varray and Nested Table Variables to NULL

·     Comparing Nested Tables for Equality and Inequality

·     Comparing Nested Tables with SQL Multiset Conditions

·     Collection Methods

·     DELETE Collection Method

·     TRIM Collection Method

·     EXTEND Collection Method

·     EXISTS Collection Method

·     FIRST and LAST Collection Methods

·     FIRST and LAST Methods for Associative Array

·     FIRST and LAST Methods for Varray

·     FIRST and LAST Methods for Nested Table

·     COUNT Collection Method

·     COUNT Method for Varray

·     COUNT Method for Nested Table

·     LIMIT Collection Method

·     PRIOR and NEXT Collection Methods

·     Collection Types Defined in Package Specifications

·     Record Variables

·     Initial Values of Record Variables

·     Declaring Record Constants

·     RECORD Types

·     Declaring Items using the %ROWTYPE Attribute

·     Declaring a Record Variable that Always Represents Full Row

·     Declaring a Record Variable that Can Represent Partial Row

·     %ROWTYPE Attribute and Virtual Columns

·     %ROWTYPE Attribute and Invisible Columns

·     Assigning Values to Record Variables

·     Assigning One Record Variable to Another

·     Assigning Full or Partial Rows to Record Variables

·     Using SELECT INTO to Assign a Row to a Record Variable

·     Using FETCH to Assign a Row to a Record Variable

·     Using SQL Statements to Return Rows in PL/SQL Record Variables

·     Assigning NULL to a Record Variable

·     Record Comparisons

·     Inserting Records into Tables

·     Updating Rows with Records

·     Restrictions on Record Inserts and Updates