How to configure SQL*Plus to display all columns on one row?
765854Apr 12 2010 — edited Apr 12 2010When I select from a table that contains large columns with a datatype like varchar(100) it displays that column on its own row. I guess it's doing this because it's allocating space for every character in that column even though that space may be unused.
For example if we have a table users:
Name Null? Type
----------------------------------------- ---------------- -------------
ID NOT NULL NUMBER(10)
FNAME NOT NULL VARCHAR2(50)
LNAME NOT NULL VARCHAR2(50)
the following select statement, select * from users, will display the following:
ID FNAME
---------- ------------------------------------------------
LNAME
--------------------------------------------------
1 John
Smith
2 Roger
Stevens
3 Ginger
Adams
Obviously there is more than enough space for LNAME. Is it possible to make all columns to appear on the same row in this case?