Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle select statements
You can try the rpad() function with the || to make all the columns the same
size.
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.
--
55 Broadway - 21st Floor
New York, New York 10006
Phone: 800.221.5327 x2136
Fax: 212-825-2245
E-Mail: MWeinstock_at_lds.com
Web: http://www.lds.com
Received on Mon Nov 01 1999 - 15:46:15 CST