The different data types are
1. Char (Fixed):
It is declared as char (size). This data type is used to store alphanumeric characters. We have to specify the size. If no size is specified, by default we can store only one character.
2. Variable Character:
It is declared as varchar (size). This data type is also used to store alphanumeric characters. But there is a slight difference. lt allocates only enough memory to store the actual size.
3. Decimal:
It is declared as Dec(size, scale), where size is the number of digits and scale is the maximum number of digits to the right of the decimal point.
Eg: weight dec(3, 2)
4. Integer:
It is declared as int. It does not have any arguments. It takes more memory.
Eg: ROllNO int.
5. Small Integer: It is declared as smallint. It takes less memory ROllNO int.
6. Date: It is used to store date.
Eg: DOB date.
7. Time: It is used to store time.
Eg: Joining_Time Time.