You can specify the
EVAL_NUMBER function in a
DUAL statement to return a numeric constant defined in an analytic workspace. Refer to Oracle Database SQL Language Reference for information on selecting from the
Note:You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.
EVAL_NUMBER ( olap_numeric_expression IN VARCHAR2) RETURN NUMBER;
An OLAP DML expression that evaluates to a number. Refer to Chapter 2, "OLAP DML Expressions".
The following example returns the value of the
DECIMALS option in the current analytic workspace. The
DECIMALS option controls the number of decimal places that are shown in numeric output. In this example, the value of
DECIMALS is 2, which is the default.
SET serveroutput ON SELECT dbms_aw.eval_number('decimals') "Decimals" FROM dual; Decimals ---------- 2