Additional Data Types

In Oracle11g, the following OLAP DML data types have been added that correspond to SQL built-in data types:

• Datetime and interval data types.You can define dimensions and surrogates with datetime data types. You can define variables, formulas, and programs with both datetime and interval data types. For more information, see "Datetime and Interval Data Types", "Datetime and Interval Expressions", and the following OLAP DML statements:

• RAW data type. For more information, see "RAW Data Type".

• Row identifier data types. more information, see "Row Identifier Data Types".:

The addition of these data types impacted the following OLAP DML statements:

CHARTOROWID function

CONVERT function

CURRENT_DATE function

CURRENT_TIMESTAMP function

DATE_FORMAT command

DBTIMEZONE function

DEFINE DIMENSION command

DEFINE VARIABLE command

EXTRACT function

FROM_TZ function

NUMTODSINTERVAL function

NUMTOYMINTERVAL function

LENGTH functions

LOCALTIMESTAMP function

ROUND (datetime) function

ROWIDTOCHAR function

ROWIDTONCHAR function

SESSIONTIMEZONE function

SYS_CONTEXT function

TO_DSINTERVAL function

TO_TIMESTAMP function

TO_TIMESTAMP_TZ function

TO_YMINTERVAL function

TRUNCATE (datetime) function

TZ_OFFSET function (11.0.0.0)

Copyright © 1994, 2007, Oracle. All rights reserved.

Previous

Next