Coupon Accepted Successfully!


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.

Test Your Skills Now!
Take a Quiz now
Reviewer Name