We have a table that are mostly CHAR datatype like below.
I've changed some of the names but the Type listed is correct. Let's just call the table blah.
Name Null? Type
-------------------------------------- -------- --------------------------
REGISTER NOT NULL CHAR(8)
DESCR NOT NULL CHAR(40)
STAT NOT NULL CHAR(1)
TYPE NOT NULL CHAR(1)
NODE NOT NULL CHAR(24)
SYSLOG_MSG NOT NULL CHAR(1)
SYSLOG_DD NOT NULL NUMBER(5)
SHIP_PROT NOT NULL CHAR(1)
DISABLED NOT NULL CHAR(1)
UPDATE_DATE NOT NULL DATE
UPDATE_TIME NOT NULL DATE
UPDATE_USER NOT NULL CHAR(8)
CREATE_DATE NOT NULL DATE
PID CHAR(8)
CLUSTER CHAR(128)
When I do a select * blah like below
set linesize 200
set trimspool on
col cluster format a25 wrapped
col descr format a25 wrapped
select *
from blah
It displays the result and fits the rows in the screen but there are a lot of blank lines in between the rows.
Is there any SQL*Plus or SQL trick maybe to NOT have these blank lines?
I thought maybe I will using format wrapped for all the CHAR datatypes but that didn't get rid of the blank lines.
I also tried using trim for most of the columns that are using the CHAR datatype and that get rid of the blank lines but it's a bit tedious doing it for each field.
I am hoping maybe there is another solution of some sort where I can use select *.
Any advice will be much appreciated. Thanks in advance.