CHAR(n) type stores a fixed-length alphanumeric value. The n indicates how long the value will be. The CHAR(n) data type pads any remaining unused space with blanks and keep the length n. The n is optional. Its default value is 1. The maximum allowed value for n is 2000.

CREATE TABLE positions(  
   id         NUMBER,
   flag       CHAR(1)
Home »
Oracle »
Data types »