What is an UTL_FILE.What are different procedures and functions associated with it?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define an oracle sub procedure?

588


How do I know if oracle client is installed on windows?

489


How to lock and unlock a user account in oracle?

607


What are dml statements in oracle?

611


What are the types of trigger in oracle?

570






How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1925


Explain oracle instance.

677


What is recovery manager(rman) backup in Oracle?

616


Why do you create or replace procedures rather that drop and recreate.

538


How to shutdown your 10g xe server from command line?

550


What is the difference between 10g OEM and 11g OEM?

559


How to handle a single quote in oracle sql?

584


Is it possible to split the print reviewer into more than one region ?

1830


How to create a testing table in oracle?

536


What is oracle datasource?

541