oracle½Å±¾ÎÊÌâ

ÎÒ Ò»¶Î
  declare v_emp t_user_p.employee_id%type ; 

  cursor c_user is select t_user_p.employee_id from t_user_p ;
  begin 
  open c_user;
  loop  
  fetch c_user into v_emp ;
  exit when c_user%NOTFOUND ;
   
  if :v_emp = '09091214' then
  goto X;
  end if ;
  -- DBMS_OUTPUT.PUT_LINE(:v_emp);  
  <<X>>
  end loop ;
  close c_user;
  end 
Ö´ÐÐ×ÜÊǵ¹ÊýµÚÈýÐеÄend loopÄÇÀﱨ´í
  
  declare v_emp t_user_p.employee_id%type ; 

  cursor c_user is select t_user_p.employee_id from t_user_p ;
  begin 
  open c_user;
  loop  
   
  end loop ;
  close c_user;
  end ;
ÕâÑùÖ´Ðл¹Êǵ¹ÊýµÚÈýÐеÄend loop±¨´í£¬
È¥µô×îºóÒ»ÐÐendºóµÄ·ÖºÅ»¹ÊÇend loop±¨´í£¬
»·¾³ÊÇpl/sql

---

Çë¸÷λ°ïæ°¡£¬¸ÕÓÃoracle£¬Ã»Ïëµ½¸ãÒ»¸ö½Å±¾¾ÍÄÑסÁË£¬ÔÚÏߵȡ£

---

DECLARE
  v_emp NUMBER;

  CURSOR c_user IS
  SELECT vendor_id from tsp_ems_t;
BEGIN
  OPEN c_user;
  LOOP
  FETCH c_user
  INTO v_emp;
  EXIT WHEN c_user%NOTFOUND;