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: Dan White <Dan_member_at_newsguy.com>
Date: 2 Nov 1999 08:51:27 -0800
Message-ID: <7vn4qf$unp@edrn.newsguy.com>


What you must do is use the concationation (||) to get rid of the spaces and Pad the fields using( rpad or lpad) to get the desired length

In article <7vmqhc$tmp$1_at_nnrp1.deja.com>, delonte_at_my-deja.com says...
>
>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 - 10:51:27 CST

Original text of this message

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