PL/SQL Explicit Cursor LOOP

-- PL/SQL Explicit Cursor LOOP


PROCEDURE GET_FILE_LIST
AS

CURSOR c_files IS
     Select FILE_NAME, FILE_TYPE, MODIFIED_DATE  from FILES_LIST;
 
   Begin


 OPEN c_files ;
 
    LOOP

      FETCH c_files  INTO rec;
      EXIT WHEN c_files %NOTFOUND;
   
     

   dbms_output.put_line(rec.file_name || rec.file_type || rec.modified_date);

   
    END LOOP;
    CLOSE c_envelop;
   

     
     

END;
/