CHAR type column : CHAR « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. CHAR

SQL>
SQL> CREATE TABLE myCharColumnTable (
  2       first_name CHAR(15),
  3       last_name  CHAR(20));

Table created.

SQL>
SQL>
SQL> INSERT INTO myCharColumnTable VALUES ('Jane', 'Smith');

1 row created.

SQL> INSERT INTO myCharColumnTable VALUES ('Christopher', 'Allen');

1 row created.

SQL> SELECT * FROM myCharColumnTable;


FIRST_NAME      LAST_NAME
--------------- --------------------
Jane            Smith
Christopher     Allen

SQL> DROP TABLE myCharColumnTable;

Table dropped.

SQL>
SQL>