游标学习

游标：

--定义游标、变量、打开、关闭
DECLARE
  CURSOR c1 IS
    SELECT cust_name FROM so1.cm_customer WHERE ROWNUM < 11;
  v_name cm_customer.cust_name%TYPE;
BEGIN
  OPEN c1;
  LOOP
    FETCH c1
      INTO v_name;
    IF c1%FOUND THEN
      DBMS_OUTPUT.PUT_LINE('Name = ' || v_name);
    ELSE
      EXIT;
    END IF;
  END LOOP;
  close c1;
END;
--不需要关闭
DECLARE
  CURSOR c1 IS
    SELECT * FROM so1.cm_customer WHERE ROWNUM < 11;
BEGIN
  for v_name in c1 loop
    DBMS_OUTPUT.PUT_LINE(v_name.cust_Id || ':' || v_name.cust_name);
  end loop;
END;
--不需要定义游标
BEGIN
  for v_name in (SELECT * FROM so1.cm_customer WHERE ROWNUM < 11) loop
    DBMS_OUTPUT.PUT_LINE(v_name.cust_Id || ':' || v_name.cust_name);
  end loop;
END;