What is an UTL_FILE.What are different procedures and functions associated with it?
- 1 Answers
- 2993 Views
- I also Faced
- E-Mail Answers
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 |
Can group functions be used in the order by clause in oracle?
How would you begin to troubleshoot an ORA-3113 error?
how to clone 9i Database on to 10g Database.
What is the Extension of Oracle Database? As extension of Access Database is .mdb
What is an oracle user role?
What are the ways tablespaces can be managed and how do they differ?
What is ceil and floor in oracle?
How to see free space of each tablespace?
How to select some columns from a table in oracle?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
What is Trace File ?
How to rollback the current transaction in oracle?
Oracle General 
