The Oracle varchar2 data type allows for the storage of up to 4000 bytes of character data. It can be defined for a column as follows:
MyColumn varchar2(100) DEFAULT ‘MyString’ NOT NULL;
Note that the varchar data type is now deprecated in Oracle as it’s usage has become a synonym for varchar2, although this may change in future versions.
Advertisement
