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
