--date2016-7-4
--select * from teachers
declaretype teachers_cursor is ref cursor;
v_teachers_cursor teachers_cursor;
v_teachers teachers%rowtype;
begin
open v_teachers_cursor for select * from teachers ;
loop
fetch v_teachers_cursor into v_teachers;
exit when v_teachers_cursor%notfound;
dbms_output.put_line(v_teachers.user_id || ' ' ||v_teachers.sex);
end loop;
close v_teachers_cursor;
end;