EVAL_TEXT Function

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.

Syntax

EVAL_TEXT ( 
          olap_text_expression     IN    VARCHAR2)
    RETURN VARCHAR2;

Parameters

Table B-21 EVAL_TEXT Function Parameters

Parameter	Description
`olap_text_expression`	An OLAP DML expression that evaluates to a character string. Refer to Chapter 2, "OLAP DML Expressions".

Example

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