Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to "append" using utl_file package?
On Wed, 18 Nov 1998 19:39:45 GMT, badstreetboy_at_my-dejanews.com wrote:
>I am trying to use the utl_file package to dump out the data into a file. As
>far as I know, what utl_file.put_line does is write out the whole line. What
>if I want to append the data to the end of the last line? What can I do?
Use UTL_FILE's procedures PUT or PUTF, which add the buffer contents
to the end of opened file, without adding the line termiantor. If you
want to put a line terminator explicitely, use the procedure
UTL_FILE.NEW_LINE.
>Thanks.
>
>BSB
HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)