Creating ASCII file from Oracle

From: <delonte_at_my-deja.com>
Date: Tue, 02 Nov 1999 13:55:59 GMT
Message-ID: <7vmqhc$tmp$1@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 - 07:55:59 CST