Oracle SQL Question: Download Questions PDF
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
Answer:
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.
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.
Download SQL Oracle Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain What is difference between SUBSTR and INSTR? | Explain Which is more faster - IN or EXISTS? |