Ok, maybe I'm just dumb, but I can't seem to find the answer to this anywhere. When I make a query using SQL/Plus it returns results with a metric shit ton of extra spaces, even though those spaces aren't stored in the database. For example, if I querry for a list of names I get output that looks like this:

F_NAME
------------------------------------------------------------
JAMES
KENNY
LANDO
MISSY

12/6/2007 12:50:16 AM

is there a trim or rtrim function you can use or variable you can set?

12/6/2007 8:58:51 AM

tried that, it seems to be something that sqlplus is doing in the output. If I change the linesize, the number of extra spaces changes (to a degree) but I can never shrink it down enough.

12/6/2007 10:18:47 AM

try this out, works for me but now i use toad

Quote :

" SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET HEADING OFF"

12/6/2007 6:24:16 PM