select dmmc from jc_dmk_1 请问有多少条记录呢?真不明楼主意图用游标实现吧,插入到数组里去! declare type t_arr is varray(100) of jc_dmk_1.dmmc%type; v_arr t_arr:=t_arr(1,2,3......) cursor t_sor is select dmmc from jc_dmk_1; num number:=1 begin for v_sor in t_sor loop v_arr(num)=v_sor.dmmc; num=num+1; end loop; end;
declare
type t_arr is varray(100) of jc_dmk_1.dmmc%type;
v_arr t_arr:=t_arr(1,2,3......)
cursor t_sor is
select dmmc from jc_dmk_1;
num number:=1
begin
for v_sor in t_sor loop
v_arr(num)=v_sor.dmmc;
num=num+1;
end loop;
end;