Re: Oracle select statements

Try this

select rtrim(field1)||' '||rtrim(field2)||' '||rtrim(field3)......

This way you get spaces between returned columns and no extra spaces in the returned column data ...

hth

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.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Nov 01 1999 - 15:41:06 CST