Formatting Truncation/Wrapping 1

[sxschech]

I added a few cols to my sql*plus code and changed the line size from 110 to 130. That caused the headers to truncate and/or wrap. Any thoughts. Here is relevant code and sample output. Notice how Hold only shows "HO" and the dashes don't go all the way across. The numbers seem to show up ok though.

[tt]
Term L Co APPLIED ACCEPTED NETACCEPTED DEPOSITED CANCELLED DENIED WITHDRAWN WAITLIST HO
------ - -- ---------- ---------- ----------- ---------- ---------- ---------- ---------- ----------
200740 LA 1111 2222 3333 444 5555 666 0 777 8
---------- ---------- ----------- ---------- ---------- ---------- ---------- ---------- ------
Total 1111 2222 3333 444 5555 6666 0 777 88
[/tt]

SET PAGESIZE 70
SET LINESIZE 130
..
..
COLUMN ACADEMIC_PERIOD    HEADING "Term"  FORMAT A6
COLUMN Student_Population HEADING "Level" FORMAT A1
COLUMN College            HEADING "College" FORMAT A2
COMP SUM OF APPLIED     ON Term
COMP SUM OF ACCEPTED    ON Term
COMP SUM OF NETACCEPTED ON Term    
COMP SUM OF DEPOSITED   ON Term
COMP SUM OF CANCELLED   ON Term
COMP SUM OF DENIED      ON Term
COMP SUM OF WITHDRAWN   ON Term
COMP SUM OF WAITLIST    ON Term
COMP SUM OF HOLD        ON Term
COMP SUM LABEL 'Z' OF APPLIED     ON Student_Population
COMP SUM OF ACCEPTED    ON Student_Population
COMP SUM OF NETACCEPTED ON Student_Population    
COMP SUM OF DEPOSITED   ON Student_Population
COMP SUM OF CANCELLED   ON Student_Population
COMP SUM OF DENIED      ON Student_Population
COMP SUM OF WITHDRAWN   ON Student_Population
COMP SUM OF WAITLIST    ON Student_Population
COMP SUM OF HOLD        ON Student_Population
COMP SUM LABEL 'Total' OF APPLIED     ON REPORT
COMP SUM OF ACCEPTED    ON REPORT
COMP SUM OF NETACCEPTED ON REPORT    
COMP SUM OF DEPOSITED   ON REPORT
COMP SUM OF CANCELLED   ON REPORT
COMP SUM OF DENIED      ON REPORT
COMP SUM OF WITHDRAWN   ON REPORT
COMP SUM OF WAITLIST    ON REPORT
COMP SUM OF HOLD        ON REPORT
BREAK ON Term ON REPORT
BREAK ON Student_Population SKIP 1 ON REPORT 
SELECT .....

 

[SantaMufasa]

Sxschech,

I'll bet that you are using a GUI version of SQL*Plus, right? (...meaning that your SQL*Plus screen has the menus "File Edit Search Options Help" across the top of your screen.)

To resolve your problem, please try the following:

On your SQL*Plus screen, click [Options] -> [Environment] -> (Screen Buffer / Buffer Width:) [b]200[/b]

Also, It won't hurt to "set linesize 200" just for the sake of resolving your problem. (I other words, it shouldn't matter if you set your linesize to more than you need.)

Try all this and let us know what happens.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[sxschech]

Thanks so much. That was the issue.