Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The OLAP_ON
function returns a boolean indicating whether or not the OLAP option is installed in the database.
Note:
You cannot execute this function from within the OLAP Worksheet. You must execute if in a SQL tool such as SQL*Plus.OLAP_ON ( ) RETURN BOOLEAN;
The value of the OLAP
parameter in the V$OPTION
table.
The following PL/SQL code tests the value returned by OLAP_ON
and returns a status message.
BEGIN IF dbms_aw.olap_on() = true THEN dbms_output.put_line('The OLAP option is installed'); ELSE dbms_output.put_line('The OLAP option is not installed'); END IF; END; / The OLAP option is installed