ORACLE:How to loop string array ?
DECLARE
type name_string_list is varray(10) of varchar2(56);
type t_name_string_list is table of varchar2(56);
v_name_string_list name_string_list;
v_test_list t_name_string_list;
BEGIN
v_name_string_list:= name_string_list('zhangsan', 'lisi');
for voc in 1 .. v_name_string_list.count
loop
dbms_output.put_line(v_name_string_list(voc));
end loop;
END;
/
浙公网安备 33010602011771号