declare
type numbers is table of number;
n numbers;
begin
n.extend;
select a into n(1) from bc_3 where b=1;
for i in1 .. n.count loop
dbms_output.put_line(n(i));
end loop;
end;
|
declare
type numbers is table of number;
n numbers:= numbers();--这一步便对该table进行初始化,像java吧。
begin
n.extend;
select a into n(1) from bc_3 where b=1;
for i in1 .. n.count loop
dbms_output.put_line(n(i));
end loop;
end;
|
declare
type numbers is table of number index by binary_integer;
n numbers;
begin
select a into n(1) from bc_3 where b=1;
select a into n(2) from bc_3 where b=3;
for i in1 .. n.count loop
dbms_output.put_line(n(i));
end loop;
end;
|
declare
type numbers is table of number;
n numbers := numbers();
begin
n.extend;--这一句加上就不会出错啦
select a into n(1) from bc_3 where b=1;
for i in1 .. n.count loop
dbms_output.put_line(n(i));
end loop;
end;
|