set column width by setting char number : CHAR « Data Type « Oracle PL / SQL






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

1.The CHAR data type is used for storing fixed-length character strings.
2.char type with 50 characters
3.Define varchar2 type variable
4.Comparison of CHAR with VARCHAR2
5.Define and use char value
6.CHAR() and VARCHAR2()
7.'' represents a zero length character string BUT NOT a null value
8.No equality comparison between two '' strings
9.Compare char value without knowing the case
10.Convert string to clob
11.char type and varchar2 type
12.Memory allocation differences between the CHAR and VARCHAR2 datatypes