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)
);
Home »
Oracle »
Data types » 

Related: