another newbie sql question , Re: ALTER

From: Lee Gold <leegold_at_erols-nospam-.com>
Date: Tue, 30 Nov 1999 02:49:35 -0500
Message-ID: <81vvgp$7sg$1@autumn.news.rcn.net>

(I'm using: SQL*Plus: Release 3.3.4.0.0 Personal Oracle7 Release 7.3.4.0.0 PL/SQL Release 2.3.4.0.0)

QUES:
note at very bottom, that the col heading "DIVISION" was truncated w/the "N" chopped off
is there a linkage between the char(6) and the col heading? why'd it do that? ?

SQL> CREATE TABLE TEAMS

  2  (TEAMNO    SMALLINT  NOT NULL,
  3   PLAYERNO  SMALLINT  NOT NULL,
  4   DIVISION  CHAR(6)   NOT NULL,

5 PRIMARY KEY (TEAMNO) )
6 ;

Table created.

SQL> INSERT INTO TEAMS VALUES (1, 6, 'first');

1 row created.

SQL> INSERT INTO TEAMS VALUES (2, 27, 'second');

1 row created.

SQL> SELECT * FROM TEAMS; TEAMNO PLAYERNO DIVISI

---------------- -------- 1 6 first 2 27 second

Received on Tue Nov 30 1999 - 01:49:35 CST