Working with Collections in Oracle PL/SQL

In this course, we will take an in-depth look at the collection types available in PL/SQL, namely Associative Arrays, Varrays, and Nested Tables. We'll also talk about the bulk fetch and collect features which greatly enhance the performance our PL/SQL code.
Course info
Rating
(81)
Level
Intermediate
Updated
May 8, 2015
Duration
4h 53m
Table of contents
Need for Collection Types & Their Characteristics
Associative Arrays
Collection Methods
Nested Tables
Nested Tables: Comparison, TABLE & MULTISET Operators
Varrays
Multilevel Collections & Converting Collections
Bulk Operations: Bulk Collect
Bulk Operations: FORALL
Description
Course info
Rating
(81)
Level
Intermediate
Updated
May 8, 2015
Duration
4h 53m
Description

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.

About the author
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
Oracle REST Data Services
Beginner
5h 32m
Feb 13, 2018
Getting Productive with SQL Developer
Beginner
3h 54m
Apr 20, 2017
More courses by Pankaj Jain