You can use the following syntax to check the data type of a specific column in a table.
TABLE_NAME = 'table_name' AND
COLUMN_NAME = 'column_name'
You can also use the describe statement to check the datatypes of all the columns of the table as follows:
If you are interested in SQL, then check out this SQL Course by Intellipaat that offers instructor-led training, certification, and job assistance.