Google News
logo
Oracle - Interview Questions
How will you differentiate between Varchar and Varchar2?
Both Varchar & Varchar2 are the Oracle data types which are used to store character strings of variable length. To point out the major differences between these,

Varchar : 
* Can store characters up to 2000 bytes.
* It will hold the space for characters defined during declaration even if all of them are not used

Varchar2 :
* Can store characters up to 4000 bytes.
* It will release the unused space
Advertisement