Wednesday, 17 May 2017

UTL_File package programs


Below are the UTL_FILE packages units.



Program Name
Either Procedure or Function
Use of it
FCLOSE
Procedure
Closes a file
FCLOSE_ALL
Procedure
Closes all open file handles
FCOPY
Procedure
Copies a contiguous portion of a file to a newly created file
FFLUSH
Procedure
Physically writes all pending output to a file
FGETATTR
Procedure
Reads and returns the attributes of a disk file
FGETPOS
Function
Returns the current relative offset position within a file, in bytes
FOPEN
Function
Opens a file for input or output
FOPEN_NCHAR
Function
Opens a file in Unicode for input or output
FREMOVE
Procedure
Deletes a disk file, assuming that you have sufficient privileges
FRENAME
Procedure
Renames an existing file to a new name, similar to the UNIX mv function
FSEEK
Procedure
Adjusts the file pointer forward or backward within the file by the number of bytes specified
GET_LINE
Procedure
Reads text from an open file
GET_LINE_NCHAR
Procedure
Reads text in Unicode from an open file
GET_RAW
Procedure
Reads a RAW string value from a file and adjusts the file pointer ahead by the number of bytes read
IS_OPEN
Function
Determines if a file handle refers to an open file
NEW_LINE
Procedure
Writes one or more operating system-specific line terminators to a file
PUT
Procedure
Writes a string to a file
PUT_LINE
Procedure
Writes a line to a file, and so appends an operating system-specific line terminator
PUT_LINE_NCHAR
Procedure
Writes a Unicode line to a file
PUT_NCHAR
Procedure
Writes a Unicode string to a file
PUTF
Procedure
A PUT procedure with formatting
PUTF_NCHAR
Procedure
A PUT_NCHAR procedure with formatting, and writes a Unicode string to a file, with formatting
PUT_RAW
Procedure
Accepts as input a RAW data value and writes the value to the output buffer

No comments:

Post a Comment