create or replace procedure prm_id is table1_row table1%rowtype; cursor c_grid is select grade_id from 年级表;--获取年级id cursor c_claid(pi_grade_id) is select class_id where 班级表.grade_id=pi_grade_id;--根据年级id获取班级id begin for c1 in c_grid loop for c2 in c_claid(c1.grade_id) loop dbms_output.putline(c2.class_id); end loop; end loop; end prm_id;
cursor c_grid is select grade_id from 年级表;--获取年级id
cursor c_claid(pi_grade_id) is select class_id where 班级表.grade_id=pi_grade_id;--根据年级id获取班级id
begin
for c1 in c_grid loop
for c2 in c_claid(c1.grade_id) loop
dbms_output.putline(c2.class_id);
end loop;
end loop;
end prm_id;