PLSQL TABLE类型的遍历

方法一：

-- TABLE 类型的遍历
declare 
  i integer ;
  rec_coverage_new gums_package_underwriting.salary_changed_tab;--table类型
begin
       rec_coverage_new := gums_package_underwriting.get_salary_changed_info("PA01000002608233");

       i := rec_coverage_new.first;
       loop
                  exit  when i is null;
       dbms_output.put_line(i);         
       i := rec_coverage_new.next(i);       
       end loop;     
end;

 

方法二：

declare 
  i integer ;
  rec_coverage_new gums_package_underwriting.salary_changed_tab;--table类型
begin
       rec_coverage_new := gums_package_underwriting.get_salary_changed_info("PA01000002608233");
       i := 0;
       while i<rec_coverage_new.count loop
           i :=i+1;                   --从1开始
           dbms_output.put_line(i);  
       end loop;     
end;

 

方法三：

declare 
  i integer ;
  rec_coverage_new gums_package_underwriting.salary_changed_tab;--table类型
begin
       rec_coverage_new := gums_package_underwriting.get_salary_changed_info("PA01000002608233");
       i := rec_coverage_new.first ;

       while i<= rec_coverage_new.last loop
           --从1开始
           dbms_output.put_line(i); 
           --i :=i+1;  
           i := rec_coverage_new.next(i);  
       end loop;      
end;