1 | TYPE varchar2_array_type IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER; |
1 2 3 4 5 6 7 8 9 10 | 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; |