GeekInterview.com
Series: Subject: Topic:
Question: 377 of 427

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.
Asked by: Interview Candidate | Asked on: Aug 29th, 2004
Showing Answers 1 - 2 of 2 Answers
Rakesh

Answered On : Mar 20th, 2007

Utl_file is oracle procedure tht enable file access .You can write ,read to file.Also possible is to del or rename a file.It requires the use of a directory object.

  
Login to rate this answer.
g_sidhu

Answered On : Feb 6th, 2008

With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and Functions:• Function FOPEN• Function IS_OPEN• Procedure GET_LINE• Procedure PUT, PUT_LINE, PUTF• Procedure NEW_LINE• Procedure FFLUSH• Procedure FCLOSE, FCLOSE_ALL

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.