Data types in SQL

Data types in SQL

Data type is nothing but type of the data

Data types used in SQL : 

• String type values : 
• CHAR : length vary between  1 to 1000 bytes
• VARCHAR : length vary between  1 to 2000 bytes
• VARCHAR2 : length vary between  1 to 4000 bytes
• LONG : upto 2 GB 

• Numeric type values : 

• NUMBER
• INTGER

• Date type values : 

• DATE