ALLOCOPS

The ALLOCOPS function returns the keywords for all of the allocation operators that you can specify in a RELATION (for allocation) statement, listed one name on each line in a multiline text value.

Return Value

TEXT

Syntax

ALLOCOPS

Examples

OLADM1500 Example 7-11 Displaying a List of the Allocation Operators

When you issue a a ALLOCOPS statement, Oracle OLAP returns a list of all of the allocation operators.

SHOW ALLOCOPS

FIRST
LAST
HFIRST
HLAST
MIN
MAX
EVEN
HEVEN
COPY
HCOPY
PROPORTIONAL

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