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 about functional dependency and its relation with table design?
Explain the use of log option in exp command.
What is the disadvantage of User defind function?
What is SQL access advisor in Oracle?
What is private procedure oracle?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
What is the exact use of Collections?
Explain the characteristics of oracle dba?
After update how do u know how many records got updated
How to see free space of each tablespace?
What is meant by joins?
What is a lookup table in oracle?