frename oracle 1

frename oracle

UTL_FILE.FRENAME('USER_DIR_ORIGIN', 'filename_origin.txt', 'USER_DIR_DESTINATION', 'filename_destination.txt', FALSE);

--the last flag is the "overwrite", the default value is FALSE

Here is what the above code is Doing:
1. It’s creating a file handle for the file we want to rename.
2. It’s renaming the file.
3. It’s closing the file handle.

Similar Posts