look at
set space value
delonte_at_my-deja.com wrote in message <7vku1b$je6$1_at_nnrp1.deja.com>...
>I have been trying to create a text data-file by spooling the results of
>a select statement to file. The problem is, Oracle puts a space between
>the returned columns of a select statement. I know about concatenating
>columns using '||', but that gets rid of all spaces between the selected
>fields, not just the one being inserted by oracle.
>
>Is there a way to get rid of the space between columns, which are being,
>added to separate data elements while maintaining the spaces within the
>field when oracle returns SQL results?
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Nov 01 1999 - 16:31:35 CST
