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
How do I manually create a database in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to load data from external tables to regular tables?
How to create a new table in oracle?
What is tns service name?
What is a proxy object?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
various types of hints and their usage
What is catalog in Oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is the sid in oracle?
How to convert a string to a date in oracle database?
What do database buffers contain?
Explain what does a control file contain?
Is oracle the best database?