<div>
Originally there was a VARCHAR datatype. &nbsp;It was improved upon and both the VARCHAR and VARCHAR2 datatypes existed simultaneously. Then at some point, VARCHAR datatype disappeared. &nbsp;If you use VARCHAR instead of VARCHAR2, you will still get a VARCHAR2 datatype.<br />
<br />
<br />
Andrew
</div>


Originally there was a VARCHAR datatype.  It was improved upon and both the VARCHAR and VARCHAR2 datatypes existed simultaneously. Then at some point, VARCHAR datatype disappeared.  If you use VARCHAR instead of VARCHAR2, you will still get a VARCHAR2 datatype.


Andrew

<div>
Listening...I'm interested in the answer, too, and was hoping somebody knew what that improvement over VARCHAR was.
</div>


Listening...I'm interested in the answer, too, and was hoping somebody knew what that improvement over VARCHAR was.

<div>
<div class="content wysiwyg-content">
what is the history of varchar2.I mean why it is varchar2<br />
rather varchar.
</div>
</div>


what is the history of varchar2.I mean why it is varchar2
rather varchar.

varchar2

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.