Skip Headers
Oracle® OLAP DML Reference
11g Release 2 (11.2)

Part Number E17122-07
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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