MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Working with Collections in Oracle PL/SQL

Course Summary

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 Syllabus

    Need for Collection Types & Their Characteristics
    - 13m 22s

    —Module Overview 4m 4s
    —Prerequisites, Audience & Tools 2m 22s
    —Need for Collection Types 2m 27s
    —Notating Collections & Characteristics 3m 32s
    —Summary 0m 55s
    Associative Arrays
    - 40m 23s

    —Module Overview 0m 50s
    —Defining Associative Arrays 4m 1s
    —Assigning Values to Associative Arrays 3m 35s
    —Demo: Assigning Values & Cursor Fetch to Associative Arrays 4m 12s
    —Associative Array Index 2m 20s
    —Demo: Associative Array Index 1m 15s
    —Exceptions with Associative Arrays 2m 26s
    —Demo: Exceptions 1m 34s
    —FIRST & NEXT Collection Methods 4m 29s
    —Demo: Associative Array Sorting 2m 27s
    —Visibility & Session Persistence 3m 18s
    —Demo: Session Persistence 5m 58s
    —Oracle Supplied Associative Arrays 1m 11s
    —Comparing Associative Arrays 0m 52s
    —Usage Guidelines 0m 43s
    —Summary 1m 4s
    Collection Methods
    - 20m 42s
    Nested Tables
    - 46m 12s
    Nested Tables: Comparison, TABLE & MULTISET Operators
    - 45m 45s
    - 35m 24s
    Multilevel Collections & Converting Collections
    - 29m 45s
    Bulk Operations: Bulk Collect
    - 22m 55s
    Bulk Operations: FORALL
    - 38m 9s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url