Back to course list
- Level: Intermediate
- Duration: 04h 51m 55s
- Release date: 2015-05-08
- Author: Pankaj Jain
- Provider: Pluralsight
Working with Collections in Oracle PL/SQL
Description
Content
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.
- Need for Collection Types & Their Characteristics13m
- Module Overview04m
- Prerequisites, Audience & Tools02m
- Need for Collection Types02m
- Notating Collections & Characteristics04m
- Summary01m
- Associative Arrays39m
- Module Overview01m
- Defining Associative Arrays04m
- Assigning Values to Associative Arrays04m
- Demo: Assigning Values & Cursor Fetch to Associative Arrays04m
- Associative Array Index02m
- Demo: Associative Array Index01m
- Exceptions with Associative Arrays02m
- Demo: Exceptions02m
- FIRST & NEXT Collection Methods04m
- Demo: Associative Array Sorting02m
- Visibility & Session Persistence03m
- Demo: Session Persistence06m
- Oracle Supplied Associative Arrays01m
- Comparing Associative Arrays01m
- Usage Guidelines01m
- Summary01m
- Collection Methods21m
- Module Overview02m
- LAST, EXISTS, DELETE & PRIOR Methods05m
- Demo: Last, Exists, Delete & Prior Methods03m
- TRIM & EXTEND methods02m
- Iterating Over Collections04m
- Demo: Iterating Over Collections04m
- Summary01m
- Nested Tables45m
- Module Overview02m
- Declare & Initialize Nested Tables04m
- Demo: Initialization01m
- Adding Elements05m
- Removing Elements01m
- Nested Table Assignments01m
- Demo: Nested Table Assignments05m
- Exceptions03m
- Trim Method02m
- Demo: Trim Method04m
- Schema Level Nested Tables06m
- DML on Nested Table Columns05m
- Demo: DML on Nested Table Columns05m
- Summary01m
- Nested Tables: Comparison, TABLE & MULTISET Operators46m
- Module Overview01m
- Table Expression04m
- Demo: Table Expression03m
- Piecewise DML06m
- Demo: Piecewise DML03m
- MULTISET Operators10m
- SET Operator01m
- Demo: MULTISET and SET Operators06m
- Comparing Nested Tables06m
- Demo: Comparing Nested Tables04m
- Summary02m
- Varrays36m
- Characteristics & Usage Guidelines04m
- Defining & Initializing Varrays03m
- Demo: Defining & Initializing Varrays02m
- Extending & Reducing Varray Size and Varray Assignments05m
- Demo: Extending & Reeducing Varray Size and Varray Assignments05m
- Exceptions01m
- Demo: Exceptions02m
- Schema Level Varrays03m
- DML Against Varrays in Database Tables04m
- Demo: DML Against Varray Columns & TABLE Expression05m
- Summary02m
- Multilevel Collections & Converting Collections28m
- Overview02m
- Associative Array Within Associative Array03m
- Demo: Associative Array Within Associative Array03m
- Nested Table Within VARRAY02m
- Nested Table Within Nested Table04m
- Demo: Multilevel Collections05m
- CAST and COLLECT Functions05m
- Demo: CAST and COLLECT Functions03m
- Summary01m
- Bulk Operations: Bulk Collect24m
- Overview02m
- Context Switches02m
- Bulk Collect03m
- Bulk Collect with Direct Select03m
- Demo: Bulk Collect with Direct Select02m
- Bulk Collect with Cursor Fetch03m
- Demo: Bulk Collect with Cursor Fetch & Performance Comparison03m
- Bulk Collect with Dynamic SQL and Returning into Statements02m
- Demo: Bulk Collect with Dynamic SQL and Returning into Statements02m
- Summary02m
- Bulk Operations: FORALL37m
- Overview02m
- Usage03m
- Demo: Usage of FORALL Clause02m
- FORALL Considerations03m
- VALUES OF and INDICES OF Clause03m
- Demo: VALUES OF and INDICES OF Clause03m
- SQL%BULK_ROWCOUNT04m
- SQL%BULK_EXCEPTIONS08m
- Demo: SQL%BULK_EXCEPTIONS & SQL%BULK_ROWCOUNT05m
- Demo: Performance Gain with FORALL03m
- Summary01m
Random courses
- The Complete Networking Fundamentals Course. Your CCNA start
- Business AutoPilot
- Adobe Premiere Pro CC: Video Editing in Adobe Premiere Pro
- Unity 3D: Lunchtime Lessons
- Beginners course on Silhouette Digital Art Techniques
- Ethical Hacking: Hacking Mobile Platforms
- Digital Painting For Beginners
- IDisposable Best Practices for C# Developers
- Social Media Marketing Trends
- Kubernetes for the Absolute Beginners - Hands-on
Latest courses
- Ember.js: The Documentary
- GraphQL: The Documentary
- AWS Certified Solutions Architect - Professional (SAP-C01) Cert Prep: 1 Design for Organizational Complexity
- CCSP Cert Prep: 4 Cloud Application Security
- What Business Leaders Need to Know about Web3 (+ Metaverse)
- Building No-Code Apps with AppSheet: Implementation
- Automation Anywhere: The Big Picture
- Protective Technology with Apache Kafka
- Coding for Visual Learners: Learning JavaScript from Scratch
- StringBuilder Internals