Re: Oracle select statements

Assuming you are using SQL*PLUS, try

    SET COLSEP '' (single quotation marks, no space in between).

Hope this helps.

On Mon, 01 Nov 1999 20:43:29 GMT, delonte_at_my-deja.com wrote:

>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 - 23:35:47 CST