Question: what is the difference between varchar and varchar2 in oracle?
Answer: Varchar2 is the updated version of varchar and the only difference is it can store upto 4000 char in it. VARCHAR is reserved by Oracle to support distinction between NULL and empty string in future, as ANSI standard prescribes. VARCHAR2 does not distinguish between a NULL and empty string, and never will.