pl_sql_explicit_cursor_fetch.sql

declare
  CURSOR x is
  select cust_first_name,cust_last_name from customers;
  f_name customers.cust_first_name %type;
  l_name customers.cust_last_name %type;
begin
   --open
   open x;
   --fetch (loop)
   LOOP
      fetch x into f_name,l_name;
      exit when x %NOTFOUND OR x%rowcount > 10;
      dbms_output.put_line(x%rowcount || ' '||f_name || ' ' || l_name);
   END LOOP;   
   --close
   close x;
end;