日期:2014-05-17 浏览次数:20868 次
set serveroutput on;
declare
type stuRecordFor is record
(sNum MyStudent.stu_num%type,
sName MyStudent.stu_name%type
);
numName stuRecordFor;
cursor curFor(varSex varchar2) is select stu_num, stu_name from MyStudent where stu_sex = varSex;
begin
for numName in curFor('女')
loop
dbms_output.put_line('学号:' || numName.sNum || ',姓名:' || numName.sName);
end loop;
end;