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 |
How do I uninstall oracle client from windows?
How many types of segments in Oracle?
what are different types of deletes?
What is a Synonym ?
What are the predefined tablespaces in a database?
What are the types of synonyms?
Explain what are clusters?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
How to use windows user to connect to the server?
Explain an exception and its types?
how to genarate random numbers in oracle for particular row?
Give the different types of rollback segments.