Oracle select statements

From: <delonte_at_my-deja.com>
Date: Mon, 01 Nov 1999 20:43:29 GMT
Message-ID: <7vku1b$je6$1@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 - 14:43:29 CST