Basic Data Types
CHAR(n) - specifies the maximum length of the character string as the data value.
NUMBER (n,d) - specifies the total number of the digits in the numeric data field and d indicates how many of the n digits are on the right side of the decimal point. If d is omitted, only integer values will be considered.
DATE - specifies the data type 'date', consisting of century, years, month, day, hours, minutes and seconds
Note: A SQL command can be executed by putting a ";"(semicolon) at the end of a query block.
Loading Data into the Database
While inserting a row by using the INSERT command, the values of the columns must be arranged in the same order as was specified in the appropriate CREATE statement.