Re: 2 Questions for SQL*PLUS

Uzytkownik "Jan-U Reichert" <jur_at_online.fr> napisal w wiadomosci news:3bd02dce$0$32589$626a54ce_at_news.free.fr...

>Is there a way to tell sql*plus to give the full column header
> even if the value has only one char ?

There is SQL*Plus manual where u could find solution....

SQL Session:

SQL> create table test
  2 (
  3 test_column varchar2(1)
  4 );

Table created.

SQL> insert into test values ('A');

1 row inserted.

SQL> select * from test;

T
-
A

SQL> COLUMN TEST_COLUMN format A20 heading "TEST COLUMN" SQL> SELECT * FROM TEST; TEST COLUMN

SQL> Exit;

Hope it helps. Received on Tue Oct 23 2001 - 17:22:38 CEST