PL SQL Tutorial

PL SQL UTL_FILE Tutorial

     UTL_FILE package has functions and procedures to manipulate external files residing in File System..

Reading from a File
Writing into a file
Appending into a file

			 

UTL_FILE.FILE_TYPE
UTL_FILE.FOPEN()
UTL_FILE.get_line()

CREATE DIRECTORY TEST_DIR  AS 'DIR PATH'
GRANT READ,WRITE ON DIRECTORY TO [USERS][PUBLIC]

writing to a file

UTL_FILE.PUT
UTL_FILE.NEW_LINE
UTL_FILE.PUT_LINE
UTL_FILE.PUTF