Home arrow Oracle arrow Page 4 - Writing to Text Files in Oracle PL/SQL



Until now, we have read text files using PL/SQL and copied that information into Oracle tables.  Now, we shall take a look at writing to text files using PL/SQL.  Let us first go through the following program.

    f utl_file.file_type;
    s varchar2(200) := 'this is some info';
    f := utl_file.fopen('SAMPLEDATA','sample2.txt','W');

You can observe that there is not much difference apart from the following line:


Instead of using “get_line,” I am now using “put_line.”  You should also observe that I placed some string within the variable “s.”  As we are writing to the text file, we cannot use “R” anymore.  Instead we need to replace it with “W” (which stands for “Write” mode).

If no file exists in the host operating system, PL/SQL runtime automatically creates the text file (with the same file name we specify) for us and starts writing into that.  If the same file already exists in the operating system, then it erases the entire contents of that file and makes it a new one.  Therefore, you should be a bit careful when using this.

There exists one more mode, “A.” This generally stands for the “Append” mode.  It is very similar to the “W” mode except that it would never remove existing information from the text file.  In some cases, this is the best way to write (or add) information to the text file.

>>> More Oracle Articles          >>> More By Jagadish Chatarji

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: