set column width by setting char number
SQL>
SQL> CREATE TABLE test_1 (
2 first_name CHAR(15),
3 last_name CHAR(20)
4 );
Table created.
SQL>
SQL> INSERT INTO test_1 VALUES ('Jane', 'Smith');
1 row created.
SQL> INSERT INTO test_1 VALUES ('Christopher', 'Allen');
1 row created.
SQL>
SQL> SELECT * FROM test_1;
FIRST_NAME LAST_NAME
--------------- --------------------
Jane Smith
Christopher Allen
SQL>
SQL> DROP TABLE test_1;
Table dropped.
SQL>
SQL>
Related examples in the same category