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. Refer to Oracle Database SQL Language Reference for information on selecting from the DUAL table.

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 OLAP session. The value of NLS_LANGUAGE in this example is "AMERICAN".

SQL>set serveroutput on
SQL>select dbms_aw.eval_text('nls_language') from dual; 

     DBMS_AW.EVAL_TEXT('NLS_LANGUAGE')
     AMERICAN
     1 row selected.