Friday, April 27, 2012

PL/SQL: loop on array

In package:
    TYPE varchar2_array_type IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;
In package body:
ze_or_keys varchar2_array_type;
BEGIN
    FOR i in 1 .. ze_or_keys.count
    LOOP
        IF i != 1 THEN
            my_string := my_string || ' OR ';
        END IF;
        my_string := my_string || ze_or_keys(i) || '=''' || ze_or_values(i) || '''';
    END LOOP;
END;