ORACLE 数组在存储过程中的应用,现在举实例如下:

首先要初始化数组变量,然后对其分配存储数量.......

[@more@]

create or replace procedure research(username in varchar2)
as
TYPE num_t_name is varray(100) of varchar2(30) ;
a num_t_name;
c varchar2(10);
j number;
cursor mycur is
select table_name from all_tab_columns where owner=username ;
begin
a := num_t_name();
a.extend(2);
j := 1;
for cur in mycur loop
c := to_char(j,'0000');
--dbms_output.put_line(c);
a(j) := cur.table_name;
insert into T_TABLEPREPARE1(tid,tname)
values(c,a(j));
j := j + 1;
end loop;
commit;
end;

ITPub博客

ORACLE 数组在过程中的应用

最新文章