What is difference between varchar and varchar2 ?

On 2014-06-09 05:11:01.0
brajeshkumar

VARCHAR store up to 2000 bytes of characters while VCHAR2 store up to 4000. If we declare datatype as VARCHAR then it will take space for NULL values, but VARCHAR2 datatype it will not take space.

On 2014-06-09 06:45:47.0
sujata

Suppose you have taken database field like this

username varchar(10)

in this case whatever name you will enter it will take 10 byte space only.
While if your database field is like this

username varchar2(10)

It depends on the variable you are going to enter.
If the username is of length 6 it will take 6 byte space not 10 byte.

On 2014-06-09 22:23:45.0
hablu