NVARCHAR2(size) A variable-length character string with a maximum length of 4000 bytes.
NUMBER(p,s) A number with a precision (p) and scale (s). The precision ranges from 1
to 38, and the scale can be from ??“84 to 127.
LONG A variable-length character data with a length up to 2GB (231??“1).
DATE Date values from January 1st, 4712 B.C. to December 31st, 9999 A.D.
BINARY_FLOAT A 32-bit floating point number.
BINARY_DOUBLE A 64-bit floating point number.
TIMESTAMP (fractional_seconds) Year, month, day, hour, minute, second, and fractional seconds. Value
of fractional_seconds can range from 0 to 9; in other words, up to one
billionth of a second precision. The default is 6 (one millionth).
TIMESTAMP (fractional_seconds)
WITH TIME ZONE
Contains a TIMESTAMP value in addition to a time zone displacement
value. Time zone displacement can be an offset from UTC (such as
???-06:00??™) or a region name (e.g., ???US/Central??™).
TIMESTAMP (fractional_seconds)
WITH LOCAL TIME ZONE
Similar to TIMESTAMP WITH TIMEZONE, except that (1) data is
normalized to the database time zone when it is stored and (2) when
retrieving columns with this datatype, the user sees the data in the
session??™s time zone.
INTERVAL YEAR (year_precision)
TO MONTH
Stores a time period in years and months. The value of year_precision is
the number of digits in the YEAR field.
INTERVAL DAY (day_precision)
TO SECOND (fractional_seconds_
precision)
Stores a period of time as days, hours, minutes, seconds, and fractional
seconds.
Pages:
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65