Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help with UTL_FILE and new line char
If you use the utl_file.put_line procedure it should put add line terminator
for you. You could also use the utl_file.new_line procedure which inserts
new line characters. Or you could concatenate a chr(10), the ascii
equivalent of a new line. I am not sure using a '\n' will work in pl/sql.
Hope this helps,
Patrick Flahan
flahan_at_earthlink.net
Kenny Gump <kgump_at_mylanlabs.com> wrote in message
news:37453dcc.0_at_news.mountain.net...
> When you write the line out to the file use \n at the end to for new line.
>
> Kenny Gump
> OCP 7.3 DBA
>
> Ryan wrote in message ...
> >I have create a PL/SQL script that uses UTL_FILE to output strings to a
> >file. It works fine except I cannot figure out how to add a newline
> >character after each a line so a new line is inserted into the file.
> >Currently all strings are concatenated into one continuous line.
> >
> >Any help would be appreciated.
> >Please remove [NOSPAM] from email to reply.
> >
> >Ryan
> >
> >
>
>
Received on Fri May 21 1999 - 07:58:54 CDT