What is an UTL_FILE? What are different procedures and functions associated with it?
What is an UTL_FILE? What are different procedures and functions associated with it?
✍: Guest
The UTL_FILE package lets your PL/SQL programs read and write operating system (OS) text files. It provides a restricted version of standard OS stream file input/output (I/O).
Subprogram -Description
FOPEN function-Opens a file for input or output with the default line size.
IS_OPEN function -Determines if a file handle refers to an open file.
FCLOSE procedure -Closes a file.
FCLOSE_ALL procedure -Closes all open file handles.
GET_LINE procedure -Reads a line of text from an open file.
PUT procedure-Writes a line to a file. This does not append a line terminator.
NEW_LINE procedure-Writes one or more OS-specific line terminators to a file.
PUT_LINE procedure -Writes a line to a file. This appends an OS-specific line terminator.
PUTF procedure -A PUT procedure with formatting.
FFLUSH procedure-Physically writes all pending output to a file.
FOPEN function -Opens a file with the maximum line size specified.
2011-09-13, 3036👍, 0💬
Related Topics:
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function? 1000000 2011-09-05, 3369👍, 0💬