Format of output in SQL*Plus
From: Burkhard Schultheis <bschultheis_at_tde.ra.eunet.de>
Date: Tue, 10 Nov 1998 15:15:34 +0000
Message-ID: <36485896.70879A62_at_tde.ra.eunet.de>
[Quoted] Hallo everybody,
Date: Tue, 10 Nov 1998 15:15:34 +0000
Message-ID: <36485896.70879A62_at_tde.ra.eunet.de>
[Quoted] 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 Tue Nov 10 1998 - 16:15:34 CET