NUMBER - stores fixed and floating point numbers. Numbers of virtually any magnitude can be stored and are guaranteed portable among different systems operating Oracle, up to 38 digits of precision
-
positive or negative numbers in the range 1 x 10 -130 to 9.99..9 x 10 125
|
DATE - stores point-in-time values (e.g. dates and times) in a table. It stores the year (including the century), the month, the day, the hours, the minutes, and the seconds.
-
Julian dates are allowed for continuous dating from a common reference
-
Oracle date arithmetic takes account the anomalies of the calendars used throughout history
|
ROWID - every row in a non-clustered table is assigned a unique ROWID that corresponds to the physical address of a row's row piece
-
ROWIDs are the fastest means of accessing particular rows
-
can be used to see how a table is physically organized
-
they are unique identifiers for rows in a given table
|
