Datatypes
Every literal or column value manipulated through Oracle has a datatype. A value’s datatype related a fixed set of properties with the value. Widely classifying the datatypes, they can be of two kinds:
•BUILT-IN
•USER-DEFINED
The Built-in datatypes are predefined set of datatypes set in Oracle. Based on the category of data which can be stored built-in datatypes can be classified as
•Character Datatypes
•Numeric Datatype
•Date Datatype
•Raw Datatype
•Long Raw Datatype
•Lob Datatype