OLAP_ON Function
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.
Syntax
OLAP_ON ( )
RETURN BOOLEAN;
Returns
The value of the OLAP parameter in the V$OPTION table.
Example
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
HTML