My Oracle Support Banner

How to Iterate Through a Set of Nested Tables? (Doc ID 1491848.1)

Last updated on AUGUST 02, 2021

Applies to:

PL/SQL - Version 10.2.0.5 and later
Information in this document applies to any platform.

Goal

This Note illustrates how to create a list of the array names like the following:

           type t1 is table of varchar2(10);

And a variable like the following:

           l1 t1 := t1('arr1','arr2', etc.)

Then just iterate that list, obtaining a count of each array along the way.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.