Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Writing to a text file from PL/SQL
Thanks for the link, and everybody for help.
<Christopher.Jones_at_oracle.comX> wrote in message
news:u8z43kzqg.fsf_at_oracle.comX...
> Tim Cross <tcross_at_nospam.une.edu.au> writes:
>
> > Álvaro Palma Aste <queria_direccion_at_el.perla.invalid> writes:
> > From memory, I think DBMS_OUTPUT may also trim leading/trailing white
> > space - so any formatting may get modified/lost - not sure about this
> > though, I just recall something I encountered where the output was
> > modified by DBMS_OUTPUT.
>
> In SQL*Plus, SET SERVEROUTPUT syntax has an option FOR[MAT]
> {WRA[PPED]|WOR[D_WRAPPED]|TRU[NCATED]} to control formatting. See
>
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920
/a90842/ch13.htm#1012919
>
> Chris
>
> --
> Christopher Jones, Oracle Corporation, Australia.
Received on Tue Jul 23 2002 - 04:51:55 CDT