SQL>
SQL>
SQL> CREATE TABLE myVarCharColumnTable (
2 name VARCHAR2(20),
3 gender CHAR(1));
Table created.
SQL>
SQL> INSERT INTO myVarCharColumnTable VALUES ('George', 'M');
1 row created.
SQL> INSERT INTO myVarCharColumnTable VALUES ('Jane', 'F');
1 row created.
SQL>
SQL> SELECT * FROM myVarCharColumnTable;
NAME G
-------------------- -
George M
Jane F
SQL> DROP TABLE myVarCharColumnTable;
Table dropped.
SQL>
SQL>
|