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