Oracle varchar2 Data Type

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.

Leave a Reply