for data in ( select * from tableName ) : LOOP « Cursor « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Cursor
  3. LOOP
SQL>
SQL>
SQL> CREATE TABLE DEPT(
  2      DEPTNO NUMBER(2),
  3      DNAME VARCHAR2(14),
  4      LOC VARCHAR2(13)
  5  );

Table created.

SQL>
SQL> INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');

1 row created.

SQL> INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS');

1 row created.

SQL> INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO');

1 row created.

SQL> INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');

1 row created.

SQL>
SQL>
SQL> create or replace procedure implicit
  2  as
  3  begin
  4      for x in ( select * from dept )
  5      loop
  6          null;
  7      end loop;
  8  end;
  9  /

Procedure created.

SQL>
SQL>
SQL> drop table dept;

Table dropped.

SQL>
SQL>
SQL>








25.5.LOOP
25.5.1.A loop is required is to read each row in cursor returned
25.5.2.Use For loop to output data in a PL/SQL table of cursor
25.5.3.Placing cursors in nested loops
25.5.4.Exit a LOOP when cursor%NOTFOUND
25.5.5.LOOP..END LOOP Cursor Loop
25.5.6.WHILE..LOOP Cursor Loop
25.5.7.Cursor FOR Loop
25.5.8.Loop till exit when cursorName%notfound
25.5.9.for data in ( select * from tableName )
25.5.10.while cursorName%found, loop