difference between varchar and varchar2 1

difference between varchar and varchar2

Both VARCHAR & VARCHAR2 are Oracle 
data types that are used to store character
strings of variable length.

As I remember Varchar2 can store double of
Varchar datatype. Varchar2 also release
the unused characters. It is like Varchar2.0 🙂

Here is what the above code is Doing:
1. Create a table called “employees”
2. Create a column called “first_name” with a data type of VARCHAR(20)
3. Create a column called “last_name” with a data type of VARCHAR(25)
4. Create a column called “hire_date” with a data type of DATE
5. Create a column called “gender” with a data type of VARCHAR(1)
6. Create a column called “birth_date” with a data type of DATE

Similar Posts