Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Writing to a text file from PL/SQL

Re: Writing to a text file from PL/SQL

From: Jasna Prester <jasna.prester_at_viadukt.tel.hr>
Date: Tue, 23 Jul 2002 11:51:55 +0200
Message-ID: <ahj99d$b73a$1@as201.hinet.hr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US