![]() Previous |
![]() Next |
In the OLAP DML, as in other languages, a data type is a collection of values and the definition of one or more operations on those values.
The Oracle OLAP DML supports the data types outlined in Table: Summary of OLAP DML Data Types.
Summary of OLAP DML Data Types
Data Type | Abbreviation | Description |
---|---|---|
|
BOOL |
Represents the logical |
|
None |
Does not correspond to the SQL data type of the same name; but, instead, is an older data type that is unique to the OLAP DML. Day, month, and year data (but not hour and minute data) between January 1, 1000 A.D. and December 31, 9999 A.D. |
|
None |
Corresponds to the SQL Valid date range from January 1, 4712 BC to December 31, 9999 AD. The default format is determined explicitly by the |
|
None |
Corresponds to the SQL Year, month, and day values of date, and hour, minute, and second values of time up to a precision of 9 places for the fractional part of the |
|
None |
Corresponds to the SQL All values of |
|
Corresponds to the SQL All values of
The default format is determined explicitly by the |
|
|
None |
Corresponds to the SQL Stores a period of time in days, hours, minutes, and seconds. |
|
None |
Corresponds to the SQL Stores a period of time in years and months. |
|
INT |
A whole number in the range of (-2**31) to (2**31)-1. |
|
SHORTINT |
A whole number in the range of (-2**15) to (2**15)-1. |
|
LONGINT |
A whole number in the range of (-2**63) to (2**63)-1. |
|
DEC |
A decimal number with up to 15 significant digits in the range of -(10**308) to +(10**308). |
|
SHORT |
A decimal number with up to 7 significant digits in the range of -(10**38) to +(10**38). |
|
None |
A decimal number with up to 38 significant digits in the range of -(10**125) to +(10**125). |
|
None |
Up to 32,767 bytes for each line in the Database character set. This data type is equivalent to the |
|
None |
Up to 32,767 bytes for each line in UTF-8 character encoding. This data type is equivalent to the |
|
None |
Up to 8 single-byte characters for each line in the database character set. ( |
|
None |
Raw binary data of length size bytes. Maximum size is 2000 bytes. You must specify size for a RAW value. (Note that when defining a variable of this data type you specify the RANSPACE64 keyword in the DEFINE VARIABLE statement to increase the maximum number of characters for the values of the variable from nearly |
|
None. |
Base 64 string representing the unique address of a row in its table. This data type is primarily for values returned by the ROWID pseudocolumn. |
|
None |
Base 64 string representing the logical address of a row of an index-organized table. The optional size is the size of a column of type UROWID. The maximum size and default is 4,000 bytes. |
|
Specified for arguments and temporary variables in an OLAP DML program when you want to handle arguments without converting values to a specific data type. Use the WKSDATA function to retrieve the data type of an argument with a |
Categories of Data Types
Frequently, these data types are thought of as belonging to the following categories:
Numeric Data Types which are INTEGER
, SHORTINTEGER
, LONGINTEGER
, DECIMAL
, SHORTDECIMAL
, and NUMBER
Text Data Types which are TEXT
, NTEXT
and ID
.
Datetime and Interval Data Types which include the datetime data types of DATETIME
, TIMESTAMP
, TIMESTAMP_TZ
, and TIMESTAMP-LTZ
and the interval data types of DSINTERVAL
and YMINTERVAL
.
Date-only Data Type which is the DATE
data type that is unique to the OLAP DML.
Boolean Data Type which is BOOLEAN.
Row Identifier Data Types which are ROWID and UROWID.
Which OLAP DML Data Objects Can Have Which Data Type?
Different objects support the use of different data types for their values:
For variables, all of the data types are supported.
For dimensions and surrogates, the INTEGER
, NUMBER
, TEXT
, ID
(simple dimensions only), NTEXT
, DATETIME
, TIMESTAMP
, TIMESTAMP_TZ
, TIMESTAMP-LTZ
, DSINTERVAL
, and YMINTERVAL
data types are supported. Additionally, when you define a dimension of type DAY, WEEK, MONTH, QUARTER, or YEAR using a DEFINE DIMENSION (DWMQY) statement, the data type of the values of that dimension are DATE
-only.