fetch cursor till notfound : Cursor Not Found « Cursor « Oracle PL / SQL

1. Oracle PL / SQL
2. Cursor
3. Cursor Not Found

fetch cursor till notfound

  

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 explicit
  2  as
  3      rowValue   dept%rowtype;
  4      cursor c is select * from dept;
  5  begin
  6      open c;
  7      loop
  8          fetch c into rowValue;
  9          exit when c%notfound;
 10      end loop;
 11      close c;
 12  end;
 13  /

Procedure created.

SQL>
SQL>
SQL>
SQL> drop table dept;

Table dropped.

SQL>

   
    
  

Related examples in the same category