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;
/

posted @ 2018-06-05 20:53  xinyueliu  阅读(37)  评论(0)    收藏  举报