Answered Questions

  • Difference between VARCHAR and VARCHAR2?

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Ranjeet

    • Feb 27th, 2006


    Emp_name varchar(10) -  if you enter value less than 10 then remaining space can not be deleted. it used total 10 spaces.

    Emp_name varchar2(10) - if you enter value less than 10 then remaining space is automatically deleted

    Krishna Kant Kumar

    • Mar 12th, 2019

    VARCHAR is going to be replaced by VARCHAR2 in next version. So, Oracle suggests the use VARCHAR2 instead of VARCHAR while declaring data type. VARCHAR can store up to 2000 bytes of characters while ...