Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The EVAL_NUMBER
function evaluates a numeric expression in an analytic workspace and returns the resulting number.
You can specify the EVAL_NUMBER
function in a SELECT
from DUAL
statement to return a numeric 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_NUMBER ( olap_numeric_expression IN VARCHAR2) RETURN NUMBER;
Table B-20 EVAL_NUMBER Function Parameters
Parameter | Description |
---|---|
|
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