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 to change program global area (pga) in oracle?
How to convert character types to numeric types?
How to create lov dynamically at runtime & attach to text field?
How to define an anonymous procedure with variables?
Explain what are clusters?
What is a trigger and what are its types in oracle?
How to create a table interactively?
Explain the use of file option in exp command.
Can we protect our pl/sql source code?
How to upsert (update or insert into a table)?
How would you begin to troubleshoot an ORA-3113 error?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Why is oracle database so popular?
How do I escape a reserved word in oracle?
How to retrieve the count of updated rows?