declare
student_name student.stu_name%type;
student_roll student.stu_roll%type;
cursor mycursor is select stu_name,stu_roll from student where stu_roll=16378;
begin
open mycursor;
loop
fetch mycursor into student_name, student_roll;
exit when mycursor%notfound;
dbms_output.put_line(student_name ||' ' ||student_roll);
end loop;
close mycursor;
end;
Comments
Post a Comment