显式游标_cursor is_open_fetch_close

scott>--显式游标(定义_打开_提取_关闭)
scott>declare
  2  cursor c_emp is select ename from emp;
  3  v_ename emp.ename%type;
  4  begin
  5  open c_emp;
  6  fetch c_emp into v_ename;
  7  dbms_output.put_line(v_ename);
  8  close c_emp;
  9  end;
 10  /
PL/SQL procedure successfully completed.
scott>set serveroutput on
scott>r
  1  declare
  2  cursor c_emp is select ename from emp;
  3  v_ename emp.ename%type;
  4  begin
  5  open c_emp;
  6  fetch c_emp into v_ename;
  7  dbms_output.put_line(v_ename);
  8  close c_emp;
  9* end;
SMITH
 
 
 
说明游标一下子就只取一条记录,好慢哟
 
 
请使用浏览器的分享功能分享到微信等