Oracle’s relational databases are used by thousands of companies around the globe. PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural language extension for SQL which allows us to procedurally tie SQL statements to effectively define business logic. In this course, we will talk about collection types available in PL/SQL. Collections Types are an extremely important part of any programming language. The collection types, along with providing a mechanism to conveniently handle sets of data, can also boost performance. Oracle offers a rich set of collection types in Associative Arrays, Varrays, and Nested Tables. We will take an in-depth look at these powerful datatypes and get familiar with the Oracle bulk fetch and collect features which greatly enhance the performance of our PL/SQL code.
Author Name: Pankaj Jain
Author Description:
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.

Table of Contents

• Need for Collection Types & Their Characteristics
  13mins
• Associative Arrays
  40mins
• Collection Methods
  20mins
• Nested Tables
  46mins
• Nested Tables: Comparison, TABLE & MULTISET Operators
  45mins
• Varrays
  35mins
• Multilevel Collections & Converting Collections
  29mins
• Bulk Operations: Bulk Collect
  22mins
• Bulk Operations: FORALL
  38mins