Wednesday, November 29, 2017

PL/SQL Implicit Cursor LOOP

-- PL/SQL Implicit Cursor LOOP


PROCEDURE GET_FILE_LIST
AS

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


   FOR rec in c_files
     LOOP
       
        -- your logic code
        - rec.file_name
     

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

       
       
      
     END LOOP;

END;
/


No comments:

Post a Comment

AWS how to delete VPC when it has error with Network interface , Gateway decencies

   how to delete VPC when it has error with Network interface , Gateway decencies  in AWS 1. Check if it is running on EC2 instance then Sto...