Re: Format of output in SQL*Plus

I always add the following lines to either each script or the effective login.sql file:

set tab off
set trimout on
set trimspool on

Tabs are always messing up my output. The last two lines both speed up output and reduce the size of spool files because they make SQL*Plus NOT pad its output to <linesize> characters.

Regards,
Rich.

Burkhard Schultheis wrote in message <36485896.70879A62_at_tde.ra.eunet.de>...
>Hallo everybody,
>
>when I select some rows from a table, the headings do not correspond to
>the content columns. For example:
>My first column is of data type NUMBER (1), the heading name is 'ZUST',
>but the heading shows a length of 9 charakters, the content column is 6
>charakters wide. And so on. I use SQL*Plus 3.3.2.0.0 on Oracle 7.3.2.1.0
>on DEC Unix. My changes in the file glogin.sql are:
>set pagesize 40
>set linesize 32767
>set long 5000
>set feedback on
>set autocommit on
>alter session set nls_date_format = 'YYYY-MM-DD-HH24.MI.SS';
>What can I do?
>Thanks,
>
>Burkhard Schultheis
>Tele Data Electronic
>
Received on Wed Nov 11 1998 - 22:45:05 CET