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

1 Answer

0 votes
by

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.

Related questions

+1 vote
asked Jul 29, 2020 in Oracle by Hodge
0 votes
0 votes
asked Jul 29, 2020 in Oracle by Hodge
...