22,301
社区成员




coursor cur_onesalaryvalue is select 姓名 from T_PROCEDURE_TEST t where t.年龄>10;
c_row cur_onesalaryvalue%rowtype;
BEGIN
open cur_onesalaryvalue;
loop
fetch cur_onesalaryvalue into c_row;
exit when cur_onesalaryvalue%notfound;
DBMS_OUTPUT.put_line (c_row.姓名);
end loop;--关闭游标
close cur_onesalaryvalue;
END