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
OLADM341

5 OLAP DML Options

This chapter contains the following topics:

For other OLAP DML reference topics, see Chapter 4, "OLAP DML Properties", Chapter 7, "OLAP DML Functions: A - K", Chapter 8, "OLAP DML Functions: L - Z", Chapter 9, "OLAP DML Commands: A-G", and Chapter 10, "OLAP DML Commands: H-Z".

OLADM342

About Options

An OLAP DML option is a special type of analytic workspace object that specifies the characteristic of some aspect of how Oracle OLAP calculates or formats data or what Oracle OLAP operations are activated. Some options are read-only, while others are read/write options for which you can specify values. Read/write options have default values.

You can use the SET (=) command to retrieve the value of an option into a predefined variable and to specify a new value for a read/write option. Use the SHOW command to display the value of an option.

OLADM343

Options: Alphabetical Listing

A B C D E I L M N O P R S T U V W Y Z

OLADM1137A


ALLOCERRLOGFORMAT
ALLOCERRLOGHEADER
AWWAITTIME

OLADM1138B


BADLINE
BMARGIN

OLADM1139C


CALENDARWEEK
COLWIDTH
COMMAS
COMPILEMESSAGE
COMPILEWARN

OLADM1140D


DATEFORMAT
DATEORDER
DAYABBRLEN
DAYNAMES
DECIMALCHAR
DECIMALOVERFLOW
DECIMALS
DEFAULTAWSEGSIZE
DIVIDEBYZERO
DSECONDS

OLADM1141E


ECHOPROMPT
EIFBYTES
EIFEXTENSIONPATH
EIFNAMES
EIFSHORTNAMES
EIFTYPES
EIFUPDBYTES
EIFVERSION
ERRNAMES
ERRORNAME
ERRORTEXT
ESCAPEBASE
EXPTRACE

OLADM1142I


INF_STOP_ON_ERROR

OLADM1143L


LCOLWIDTH
LIKECASE
LIKEESCAPE
LIKENL
LIMIT.SORTREL
LIMITSTRICT
LINENUM
LINESLEFT
LOCK_LANGUAGE_DIMS
LSIZE

OLADM1144M


MAXFETCH
MODDAMP
MODERROR
MODGAMMA
MODINPUTORDER
MODMAXITERS
MODOVERFLOW
MODSIMULTYPE
MODTOLERANCE
MODTRACE
MONTHABBRLEN
MONTHNAMES
MULTIPATHHIER

OLADM1145N


NASKIP
NASKIP2
NASPELL
NLS_CALENDAR
NLS_CURRENCY
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_DUAL_CURRENCY
NLS_ISO_CURRENCY
NLS_LANG
NLS_LANGUAGE
NLS_NUMERIC_CHARACTERS
NLS_SORT
NLS_TERRITORY
NOSPELL

OLADM1146O


OKFORLIMIT
OKNULLSTATUS
OUTFILEUNIT

OLADM1147P


PAGENUM
PAGEPRG
PAGESIZE
PAGING
PARENS
PERMITERROR
PERMITREADERROR
POUTFILEUNIT
PRGTRACE

OLADM1148R


RANDOM.SEED.1 and RANDOM.SEED.2
RECURSIVE
ROLE
ROOTOFNEGATIVE

OLADM1149S


SECONDS
SESSCACHE
SESSION_NLS_LANGUAGE
SPARSEINDEX
SQLBLOCKMAX
SQLCODE
SQLERRM
SQLMESSAGES
STATIC_SESSION_LANGUAGE

OLADM1150T


THIS_AW
THOUSANDSCHAR
TMARGIN
TRACEFILEUNIT
TRIGGERMAXDEPTH
TRIGGERSTOREOK

OLADM1151U


USERID
USETRIGGERS

OLADM1152V


VARCACHE

OLADM1153W


WEEKDAYSNEWYEAR
WRAPERRORS

OLADM1154Y


YESSPELL
YRABSTART

OLADM1155Z


ZEROROW
ZSPELL
OLADM344

Options by Category


Analytic Workspace Options
Globalization Support
Multi-Language Support Options
Aggregation Options
Allocation Options
Model Options
Compilation Options
Error Options
Debugging Options
SQL Embed Options
File Reading and Writing Options
EIF Options
Report Options
NA Values Options
Date-only Data Type Options
Datetime Options
Numeric Options
RANK Function Monitoring Options

OLADM1156Analytic Workspace Options


AWWAITTIME
DEFAULTAWSEGSIZE

OLADM1157Globalization Support


NLS_CALENDAR
NLS_CURRENCY
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_DUAL_CURRENCY
NLS_ISO_CURRENCY
NLS_LANG
NLS_LANGUAGE
NLS_NUMERIC_CHARACTERS
NLS_SORT
NLS_TERRITORY

OLADM1158Multi-Language Support Options


LOCK_LANGUAGE_DIMS
NLS_DATE_LANGUAGE
NLS_LANG
NLS_LANGUAGE
SESSION_NLS_LANGUAGE
STATIC_SESSION_LANGUAGE

OLADM1159Aggregation Options


MULTIPATHHIER
POUTFILEUNIT
SESSCACHE
VARCACHE

OLADM1160Allocation Options


ALLOCERRLOGFORMAT
ALLOCERRLOGHEADER
POUTFILEUNIT

OLADM1161Model Options


MODDAMP
MODERROR
MODGAMMA
MODINPUTORDER
MODMAXITERS
MODOVERFLOW
MODSIMULTYPE
MODTOLERANCE
MODTRACE

OLADM1162Compilation Options


COMPILEMESSAGE
COMPILEWARN
THIS_AW

OLADM1163Error Options


BADLINE
ERRNAMES
ERRORNAME
ERRORTEXT
INF_STOP_ON_ERROR
MODERROR
PERMITERROR
PERMITREADERROR
SQLERRM
SQLMESSAGES
WRAPERRORS

OLADM1164Debugging Options


EXPTRACE
MODTRACE
PRGTRACE

OLADM1165SQL Embed Options


SQLBLOCKMAX
SQLCODE
SQLERRM
SQLMESSAGES

OLADM1166File Reading and Writing Options


ECHOPROMPT
ESCAPEBASE
INF_STOP_ON_ERROR
OUTFILEUNIT

OLADM1167EIF Options


EIFBYTES
EIFEXTENSIONPATH
EIFNAMES
EIFSHORTNAMES
EIFTYPES
EIFUPDBYTES
EIFVERSION

OLADM1168Report Options


BMARGIN
COLWIDTH
COMMAS
DECIMALCHAR
DECIMALS
LCOLWIDTH
LINENUM
LINESLEFT
LSIZE
NASPELL
NOSPELL
PAGENUM
PAGEPRG
PAGESIZE
PAGING
PARENS
THOUSANDSCHAR
TMARGIN
YESSPELL
ZEROROW
ZSPELL

OLADM1169NA Values Options


LIMITSTRICT
NASKIP
NASKIP2
NASPELL
RECURSIVE
TRIGGERMAXDEPTH
TRIGGERSTOREOK

OLADM1170Date-only Data Type Options


CALENDARWEEK
DATEFORMAT
DATEORDER
DAYABBRLEN
DAYNAMES
DSECONDS
MONTHABBRLEN
MONTHNAMES
WEEKDAYSNEWYEAR
YRABSTART

OLADM1171Datetime Options


CALENDARWEEK
DSECONDS
SECONDS

OLADM1172Numeric Options


DECIMALOVERFLOW
DIVIDEBYZERO
RANDOM.SEED.1 and RANDOM.SEED.2
ROOTOFNEGATIVE

OLADM1173RANK Function Monitoring Options


RANK_CALLS
RANK_CELLS
RANK_SORTS
Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

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

Main Categories

This Page

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF