Jul 29, 2020 in Oracle
Q: How will you differentiate between VARCHAR & VARCHAR2 data tyoes in Oracle?

1 Answer

0 votes
Jul 29, 2020

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.
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
May 11, 2020 in Oracle