What is an UTL_FILE.What are different procedures and functions associated with it?
Answer / 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 |
Explain the use of control file?
How to invoke the original export import utilities?
What is a snapshot in oracle database?
Can multiple columns be used in group by in oracle?
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 components of logical database structure in oracle database?
How to create id with auto_increment on oracle?
Can we call procedure inside function in oracle?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
How to manage transaction isolation level?
What is an Index Segment ?
what are views?