Question

How will you differentiate between VARCHAR & VARCHAR2 data tyoes in Oracle?

Answer 1

Both VARCHAR & VARCHAR2 are Oracle data types that are used to store character strings of variable length. Their differences are:

• VARCHAR can store characters up to 2000 bytes while VARCHAR2 can store up to 4000 bytes.
• VARCHAR will hold the space for characters defined during declaration even if all of them are not used whereas VARCHAR2 will release the unused space.