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

Last updated on AUGUST 02, 2021

Applies to:

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

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