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
Why do we use coalesce function in oracle?
What is difference between sid and service name in oracle?
Respected sir, Please send me technical questions related to oracle apps..
Explain parameter file in oracle.
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
how do u setup a replication site?
How index is implemented in oracle database?
What is the use of file param in imp command?
How to create a stored program unit?
Explain implicit cursor.
What is oracle server autotrace in oracle?
what is a Nested Loop join?
How to insert a record into a table?
What is SQL access advisor in Oracle?