Oracle Interview Questions Part 7
By admin on Oct 14, 2007 in Oracle Interview Questions Part 7
What is an UTL_FILE.What are different procedures and functions associated with it?
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.
Can you use a commit statement within a database trigger.
No
What is the maximum buffer size that can be specified using the DBMS_OUTPUT. ENABLE function?
1,000,000
