Both are related to varible length but difference that varchar stores only 2000 byte character of data and varchar2 stores 4000 byte charecter of data .

If any problem don't hesitate write to rahultripathi@myway.com

dear friend... here is small clarification w.r.t your answer reg...

The VARCHAR datatype is actually a subtype of VARCHAR2 with the same range of values found in VARCHAR2. VARCHAR in other words is currently synonymous with VARCHAR2. Use of VARCHAR offers compatibility with ANSI and IBM relational databases. There is a strong possibility however that VARCHAR's meaning might change in a new version of the ANSI SQL standards. Oracle recommends that you avoid using VARCHAR if at all possible and instead stick with VARCHAR2 to declare variable-length PL/SQL variables (and table columns as well).

cheerz..

dhanunjay

Ketan Pathak Wrote: The other difference is that varchar occupy total length which is define to create database while the varchar2 occupy the total length of the given string.

If we declare datatype as VARCHAR then it will occupy space for NULL values In case of VARCHAR2 datatype it will not occupy any space.

This is not right ans because varchar datatype store more than 2000 character i checked it no error found so plz anbody give right ans