The screen dump below shows the file structure information of the directory UTLDIR.
Now, as per the requirement, I need to make a copy of Demo_file.txt in the same directory. The PL/SQL block below achieves the purpose.
Check the UTLDIR new file structure as below.
Similarly, FREMOVE is used to delete a file from a directory.
In the tutorial, we saw the strength of the UTL_FILE operations. For static OS file management systems, UTL_FILE is one of the most frequent used utility in Oracle, where tasks like data loading and file operations can be easily carried out.
Oracle 11g Tutorial