STATALL

The STATALL function indicates whether default status is currently in effect for a given dimension. That is, STATALL returns YES when STATLIST would return ALL. Otherwise, STATALL returns NO.

Return Value

BOOLEAN

Syntax

STATALL(dimension)

Parameters

dimension: A text expression whose value is the name of a dimension or dimension surrogate.

Usage Notes

OLADM1913STATALL Compared to STATLIST

STATALL provides an alternative to running the STATLIST program to determine if the status of a specified dimension is ALL.

Examples

OLADM1914 Example 8-106 Using STATALL

With the following statement, you can see whether the status of the MONTH dimension is ALL.

SHOW STATALL(month)

The return value is either YES or NO.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

Installation
Getting Started
Administration
Application Development
Grid Computing
High Availability
Data Warehousing
Content Management and Unstructured Data
Information Integration
Security

This Document

Oracle® OLAP DML Reference 11g Release 2 (11.2)
OLAP DML Basic Concepts
Data Types, Operators, and Expressions
Formulas, Models, Aggregations, and Allocations
OLAP DML Properties
OLAP DML Options
OLAP DML Programs
OLAP DML Functions: A - K
OLAP DML Functions: L - Z
OLAP DML Commands: A-G
OLAP DML Commands: H-Z
OLAP_TABLE SQL Functions
DBMS_AW PL/SQL Package
OLAP_API_SESSION_INIT

New and changed documents:

HTML

PDF