What is an UTL_FILE.What are different procedures and functions associated with it?
Answer Posted / nishi
UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the differences between interval year to month and interval day to second?
How to get last row id?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are the attributes that are found in a cursor?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain an extent?
What is parameterized cursor in oracle?
What is sequence?
How do I manually uninstall oracle client?
What is the relation of a user account and a schema?
How to delete all rows a table in oracle?
how do u setup a replication site?
What do you mean by cdb and pdb in oracle 12c?
What is meant by recursive hints in oracle?
How to experiment a data lock in oracle?