|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
Text literals. For example,
Text dimensions. For example,
Text variables or formulas. For example,
Functions that yield text results. For example,
When you use a
DATETIME value where a text value (
ID) is expected, or when you store a
DATETIME value in a text variable, then the
DATETIME value is automatically converted to a text value.
The format of a
DATETIME value is controlled by the NLS_DATE_FORMAT option. Once a
DATETIME value is stored in a text variable, the NLS_DATE_FORMAT setting has no impact.
NTEXT data are interchangeable in most cases. However, implicit conversion can occur, such as when an
NTEXT value is assigned to a
TEXT variable. When
TEXT is converted to
NTEXT, no data loss occurs because the UTF-8 character encoding of the
NTEXT data type encompasses most other data types. However, when
NTEXT is converted to
TEXT, data loss occurs when
NTEXT characters are not represented in the workspace character set.
NTEXT values are used together, for example in a call to the
JOINCHARS function, the
TEXT value is converted to
NTEXT and an
NTEXT value is returned.