PLSQL数组

declare
  type t_varchar_arr is TABLE OF varchar2(60);
  type t_number_arr is TABLE OF number;
  v_date t_varchar_arr;
  v_age  t_number_arr;
begin
  v_date := t_varchar_arr('20160429', '20160516', '20163516');
  v_age  := t_number_arr(50.2, 20, 58);
  for i in 1 .. v_date.count() loop
    dbms_output.put_line(' date ' || v_date(i) || ' age ' || v_age(i));
  end loop;
end;

posted on 2016-05-27 13:24  阮減显  阅读(187)  评论(0编辑  收藏  举报

导航