Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The EVAL_TEXT
function evaluates a text expression in an analytic workspace and returns the resulting character string.
You can specify the EVAL_TEXT
function in a SELECT
from DUAL
statement to return a character constant defined in an analytic workspace. For more information, see "Selecting from the DUAL Table" in Oracle Database SQL Language Reference.
Note:
You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.EVAL_TEXT ( olap_text_expression IN VARCHAR2) RETURN VARCHAR2;
Table B-21 EVAL_TEXT Function Parameters
Parameter | Description |
---|---|
|
An OLAP DML expression that evaluates to a character string. Refer to Chapter 2, "OLAP DML Expressions". |
The following example returns the value of the NLS_LANGUAGE
option, which specifies the current language of the session.
SET serveroutput ON SELECT dbms_aw.eval_text('nls_language') "NLS Language" FROM dual;
The value of NLS_LANGUAGE
in this example is AMERICAN
.
NLS Language --------------- AMERICAN