CHAR Data type
The CHAR data type specifies a fixed-length character string. Oracle blank-pads the value to column length when data length shorter than declared.
VARCHAR2 Data type
The VARCHAR2 data type specifies a variable-length character string. Oracle stores each value in the column exactly as we enter.
NUMBER Data type
The NUMBER data type stores any numeric values. Default length will be 22 bytes. NUMBER (p, s) where s means no of digits after decimal and p intend to specify the no of digits before decimal.
DATE Data type
The DATE data type stores date and time information. DATE value, Oracle stores the following information: century, year, month, date, hour, minute, and second.
Using excel sheet we have created a table for testing purpose, whereas, we intend to create new