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: Creating ASCII file from Oracle

Re: Creating ASCII file from Oracle

From: Paul Q <paulq_at_home.com>
Date: Tue, 02 Nov 1999 14:41:39 GMT
Message-ID: <DKCT3.15000$it.416841@news2.rdc1.on.home.com>


set space 0

delonte_at_my-deja.com wrote in message <7vmqhc$tmp$1_at_nnrp1.deja.com>...
>I have been trying to create a text file from oracle by spooling results
>from a select statement to a file. The only problem is that oracle
>places a space between the each of the returned columns.
>
>(I know the concatenation '||' can be used, but this gets rid of any
>spaces within the field thus throwing the record layout of the text
>file off.)
>
>Is there anyway to get rid of the space between columns that oracle adds
>in a select statement?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Nov 02 1999 - 08:41:39 CST

Original text of this message

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