Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Append a line at the beginning of the file using plsql

JenneyMar 28 2014 — edited Mar 28 2014


Hi All,

Version: oracle 11g version

I have a requirement like to append a line(new line) at the beginning of the file.

my file is my_txt file contains lines like this

this is the first line of the file

this is the second line of the file

this is the third line of the file

Now I want to append a line to the my_txt file

this is starting

this is the first line of the file

this is the second line of the file

this is the third line of the file

I tried with UTL_FILe package PUT_LINE,PUT,NEW_LINE procedures

but all these are adding the line at the end of the file like

this is the first line of the file

this is the second line of the file

this is the third line of the file

this is starting

Please help me to get the required result

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2014
Added on Mar 28 2014
9 comments
1,283 views