1337 b4k4
All American
10033 Posts
user info
edit post |
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
The F_Name data is a varchar(20), and something similar happens for almost every column. I know I can specify the format of specific columns one at a time in SQL/Plus but is there any way to set them globaly or preferably to have SQL/Plus only output a column as long as it needs to be for the given results? 12/6/2007 12:50:16 AM
|
1337 b4k4
All American
10033 Posts
user info
edit post |
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 |
