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 laterInformation 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 |