Here is a code snippet from one of my functions that get a list of ranges,
i.e '1_10,11-100,' and separate them into a vector.
(needs comma also after last value for easier parsing).
The function operates under a package so I can retain variables between
activation of the functions.
I keep the last
otn.oracle.com go to documents. look pl/sql table. its a dynamic array.
asktom.oracle.com will have examples.
>
> From: Andrea Oracle <[EMAIL PROTECTED]>
> Date: 2003/09/10 Wed PM 01:34:25 EDT
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Subject:
Hi all,
How to work with Array in PL/SQL. I have an input
string like 12,34,56,.. I need to get the values
out and assign them to an array, and loop through the
array to call a function. Do you have sample code for
1) value assignment to array and 2) loop through
array. And it's all in pl/s