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.

Download SQL Oracle Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is difference between SUBSTR and INSTR?Explain Which is more faster - IN or EXISTS?