VARCHAR2
VARCHAR2(n)
stores a variable-length alphanumeric value.
The n indicates the maximum allowable length.
The VARCHAR2
format will not pad its values with blanks.
VARCHAR2
requires n to be specified.
The minimum value of n is 1.
The maximum allowable length of VARCHAR2
is 4000.
CREATE TABLE pos
( id NUMBER
, name VARCHAR2(20)
);