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 original export and import utilities?
What is the difference between Delete, Truncate and Drop in Oracle?
How to name query output columns in oracle?
How many types of segments in Oracle?
Explain database link?
What is tns entry?
What is oracle update statement with inner join ?
Explain the use of owner option in exp command.
Explain about your project and its relation to the current job position you are applying to?
What is the quickest way to export a table to a flat file?
Explain the characteristics of oracle dba?
What is the difference between truncate & delete command?
How to define a sub function?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is the best way to do multi-row insert in oracle?