Oracle varchar2 Data Type

If this post helps you, click an ad

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