Skip Headers
Oracle® OLAP DML Reference
10
g
Release 2 (10.2)
Part Number B14346-01
Home
Book List
Contents
Index
Master Index
Feedback
Previous
Next
View PDF
List of Examples
2-1 Using Boolean Comparisons
2-2 Report with Conditional Expression
2-3 Using Ampersand Substitution
2-4 Replacing a Dimension in a Variable
6-1 Using the $AGGMAP Property
6-2 Using the $AGGREGATE_FROM Property
6-3 Capstone Aggregation Using the $AGGREGATE_FROMVAR Property
6-4 Using $ALLOCMAP to Specify a Default Allocation Specification
6-5 Using $COUNTVAR
6-6 Creating a Language Dimension
6-7 Attaching a Language Dimension
6-8 Changing NLS_LANGUAGE
6-9 Setting NLS_LANGUAGE to a Value that is Not in a Language Dimension
6-10 Triggering Aggregation Using an $NATRIGGER
6-11 Adding an $NATRIGGER Property to a Variable
6-12 Storing an $NATRIGGER Property Value
6-13 Setting the $VARCACHE Property
6-14 Finding Values in an Absolute Range
6-15 Acquiring, Updating, and Releasing Objects
6-16 Acquiring and Resynchronizing Objects
6-17 Acquiring Objects While Keeping Consistency
6-18 Using ACROSS to Repeat ROW Commands
6-19 End-of-Month Calculation
6-20 Reporting on an Aggcount Variable
6-21 Combining Pre-calculation and Calculation on the Fly
6-22 Performing Non-additive Aggregation
6-23 Programmatically Defining an Aggmap
6-24 Creating an Aggmap Using an Input File
6-25 Using Multiple Aggmaps
6-26 Using an AGGINDEX Statement in an Aggregation Specification
6-27 Aggregating By Dimension Attributes
6-28 Using a CACHE Statement in an Aggregation Specification
6-29 Populating All Levels of a Hierarchy Except the Detail Level
6-30 Aggregating into a Different Variable
6-31 Using a MEASUREDIM Statement in an Aggregation Specification
6-32 Solving a Model in an Aggregation
6-33 Aggregating Up a Hierarchy
6-34 Using Valuesets
6-35 Aggregating with a RELATION Statement That Uses an ARGS Keyword
6-36 Aggregating Using a Measure Dimension
6-37 Aggregating Using a Line Item Dimension
6-38 Skip-Level Aggregation
6-39 Aggregation Specification with RELATION Statements That Include PRECOMPUTE Clauses
6-40 Temporarily Adding a Model to an Aggmap
6-41 Using AGGMAP SET to Specify a Default Aggmap
7-1 Retrieving Information About an Aggmap Object
7-2 Precalculating Data in a Batch Job
7-3 Aggregating One Variable
7-4 Aggregating Multiple Variables
7-5 Using COUNTVAR with Multiple Variables
7-6 Performing a Partial Aggregation
7-7 Capstone Aggregation
7-8 Aggregating a Variable with External Partitions
7-9 Using the AGGREGATE Function as the Formula of an Expression
7-10 Aggregating Data on the Fly for a Report
7-11 Using $NATRIGGER to Aggregate Data
7-12 Calculating all but one Value on the Fly
7-13 Using the AGGREGATION Function to Create a Custom Aggregate
7-14 Displaying a List of the Aggregation Operators
7-15 ALLCOMPILE Output
7-16 Direct Even Allocation
7-17 Recursive Even Allocation with a Lock
7-18 Recursive Proportional Allocation
7-19 Setting the ALLOCERRLOGFORMAT Option
7-20 Setting the ALLOCERRLOGHEADER Option
7-21 Allocation Specification from an Input File
7-22 Allocation Specification from a Text Expression
7-23 Specifying a Single Dimension Value in an Allocation Specification
7-24 Entering RELATION Statements in an Allocation Specification
7-25 Excluding CHILDLOCK Errors
7-26 Excluding All Allocation Errors
7-27 Displaying a List of the Allocation Operators
7-28 Limiting to All Values
7-29 Calculating the Value of e Raised to the Second Power
7-30 Calculating the Value of Ten Raised to the Third Power
7-31 Testing for Any True Values by District
7-32 Testing for Any True Values by Region
7-33 Calculating the Arc of a Cosine
8-1 Calculating the Arc of a Sine
8-2 Calculating the Arc of a Tangent
8-3 Assigning Arguments
8-4 Checking the Number of Arguments
8-5 Passing Arguments Using ARG and ARGFR
8-6 Passing Arguments Using ARGS
8-7 Passing an Argument to a User-Defined Function
8-8 Passing Multiple Arguments
8-9 Using the ARGUMENT Statement
8-10 Passing the Text of an Expression
8-11 Passing Workspace Object Names and Keywords
8-12 Calculating Average Monthly Sales
8-13 Assigning an Alias
8-14 Startup Programs
8-15 Attaching an Analytic Workspace Using an ONATTACH Program
8-16 Creating and Starting a Workspace
8-17 Deleting a Workspace
8-18 Detaching a Workspace
8-19 Removing all Data from a Workspace
8-20 Ascertaining the Active Workspace
8-21 Describing a Workspace
8-22 Specifying a Wait Time of One Minutes
8-23 Debugging a Program Using the BACK Function
8-24 Using the BADLINE Option
8-25 Finding Errors in Program Lines
8-26 Returning Base Dimension Names
8-27 Returning Component Dimension Names
8-28 Returning NTEXT Values
8-29 Returning the Base Values of a Base Concat Dimension
8-30 Finding the Beginning Date
8-31 Inserting Blank Lines
8-32 Stripping Leading and Trailing Blanks
8-33 Setting the Bottom Margin of a Report Page
8-34 Using BREAK with SWITCH
8-35 Aligning Weeks with the Calendar Year
8-36 Aligning Weeks with a Specified Ending Date
8-37 Calling a Program or Function
8-38 Determining the Calling Method
8-39 Specifying Category Range Values
8-40 Specifying a Group-Expression
8-41 Specifying the Current Directory Object
8-42 Obtaining the Current Directory Object
8-43 Displaying the Smallest Integer Greater Than or Equal to a Number
8-44 Changing Text Values Using Bytes
8-45 Changing the Values of Text Characters
8-46 Deleting Workspace Objects
8-47 Creating a List of Top Sales People
9-1 Using CHGDFN SEGWIDTH
9-2 Adding an External Partition to a Variable
9-3 Changing the Phase of a YEAR Dimension
9-4 Adding a Base Dimension to a Concat Dimension
9-5 Clearing a Variable's Data
9-6 Clearing Aggregated Data
9-7 Clearing Cached Data
9-8 Using COALESCE to Determine the Sales Price of a Product
9-9 Performing Column Calculations in a Report
9-10 Setting the Default Column Width in a Report
9-11 Showing Numerical Data Without Commas
9-12 Saving All Changes to an Analytic Workspace
9-13 Compiling a Program
9-14 Finding Program Errors
9-15 Suppressing Error Messages During Compilation
9-16 Specifying That You Want Compiler Warnings
9-17 Adding a Description to an Analytic Workspace Object
9-18 Saving Dimension Status
9-19 Listing Context Names
9-20 Listing Saved Values
9-21 Skipping Over Code in a FOR Loop
9-22 Converting Decimal Values to Text
9-23 Converting Text Values to Escape Sequences
9-24 Converting a Text Expression to a Date
9-25 Copying Programs
9-26 Correlating with the PEARSON Method
9-27 Calculating the Cosine of an Angle in Radians
9-28 Calculating the Cosine of an Angle in Degrees
9-29 Calculating the Hyperbolic Cosine of an Angle
9-30 Counting True Values by District
9-31 Multiple CUMSUM Calculations
9-32 Resetting for a Quarter
9-33 Changing the Format of Dates
9-34 Including Text in the Format of a Date
9-35 Changing the Date Order
9-36 Specifying Day Abbreviations
9-37 Specifying Day Names
9-38 Finding Today's Weekday
9-39 Finding the Weekday of a Date
9-40 Debugging with a Debugging File
9-41 Sending Debugging Information to a File
9-42 Finding Today's Day of the Month
10-1 Identifying the Decimal and Thousands Markers
10-2 The Effect of DECIMALOVERFLOW
10-3 Showing Data with No Decimal Places
10-4 Comparing 2 Decimal Places with Best Presentation Format
10-5 Decoding an ID Field
10-6 DECODE with BITAND
10-7 Displaying the Maximum Segment Size for a Session
10-8 Setting the Maximum Segment Size for a Session
10-9 Creating an Aggmap for Aggregation
10-10 Creating an Aggmap for Allocation
10-11 Creating a Named b-Tree Composite
10-12 Defining a Simple Dimension
10-13 Defining a YEAR Dimension
10-14 Using the Default Phrase for Date in an ENDING Phrase
10-15 Defining a Conjoint Dimension
10-16 Defining a CONCAT Dimension
10-17 Defining an Alias Dimension
10-18 Defining a Formula
10-19 Defining a Simple Model
10-20 Basing Program Flow on Test Results
10-21 Creating, Populating, and Totaling by a Relation
10-22 Creating an INTEGER Dimension Surrogate
10-23 Creating a NUMBER Dimension Surrogate
10-24 Creating and Assigning Values to a Valueset
10-25 Creating and Assigning Values to a Multidimensional Valueset
10-26 Defining an INTEGER Variable with One Regular Dimension
10-27 Defining a Single-Cell Variable
10-28 Defining NUMBER Variables
10-29 Defining a Variable Dimensioned by Two Regular Dimensions
10-30 Defining a Variable Dimensioned by an Uncompressed Composite
10-31 Defining a Variable Dimensioned by a Compressed Composite
10-32 Defining a Variable with Internal Partitions
10-33 Defining a Variable with External Partitions
10-34 Defining a Fixed-Width TEXT Variable
10-35 Defining a Variable That Uses a Named B-Tree Composite
10-36 Defining a Worksheet
10-37 Importing Spreadsheet Data
10-38 Deleting a Dimension
11-1 Using DEPRDECL to Calculate Depreciation Expenses for Assets Acquired in a Single Period
11-2 Using DEPRDECL to Calculate the Depreciation Expenses for Assets Acquired in Multiple Periods
11-3 Calculating Depreciation Expenses for Assets Acquired in a Single Period
11-4 Specifying the Switch Period
11-5 Calculating the Depreciation Expenses for Assets Acquired in Multiple Periods
11-6 Using DEPRSL to Calculate Depreciation Expenses for Assets Acquired in a Single Period
11-7 Using DEPRSL to Calculate the Depreciation Expenses for Assets Acquired in Multiple Periods
11-8 Using DEPRSOYD to Calculate Depreciation Expenses for Assets Acquired in a Single Period
11-9 Using DEPRSOYD to Calculate the Depreciation Expenses for Assets Acquired in Multiple Periods
11-10 Describing Variables
11-11 Describing All Relations
11-12 Describing a Worksheet
11-13 The Effect of DIVIDEBYZERO
11-14 DO and DOEND with the FOR Statement
11-15 Timing a Program Using DSECONDS
11-16 Using ECHOPROMPT
11-17 Editing a Program
11-18 Editing a Model
11-19 Finding Out the Number of Bytes
11-20 Establishing a Location for Extension Files
11-21 Limiting the Extension of a File Name to Three Characters
11-22 Checking What You Have Imported
11-23 Reducing Update Frequency
11-24 Exporting and Importing Between Different Versions
11-25 Finding the End Date
11-26 Finding the Fiscal Year End Date
11-27 Adding an EQ
11-28 Using PARSE with EQ
11-29 ERRORTEXT Value Depending on ERRNAMES Setting
11-30 Using ERRORNAME with TRAP
11-31 ERRORTEXT with the SIGNAL Command
11-32 Obtaining the Version Number
11-33 Testing for All-True Values by District
11-34 Testing for All-True Values by Region
11-35 Using EXISTS
12-1 Exporting Variables
12-2 Exporting a Large Object
12-3 Limiting Before Exporting
12-4 Tracing System DML Programs
12-5 Extracting Text Characters Using Bytes
12-6 Extracting Text Characters
12-7 Extracting Text Columns
12-8 Extracting One Text Line
12-9 A Forecasting Program
12-10 Querying a Forecast
12-11 Program That Opens and Closes a File
12-12 Copying a File
12-13 Specifying the File Using a Variable
12-14 Error-Handling with TRAP
12-15 Program for Reading a File
13-1 Program That Uses FILENEXT
13-2 FILEOPEN with an Argument Passed into a Program
13-3 FILEOPEN with a Binary File
13-4 Using the FILEPAGE Command
13-5 Writing Data to a File Using FILEPUT
13-6 Preprocessing Data
13-7 Setting Paging Options for a File Opened for Writing
13-8 Dimension Values and Data
13-9 Dimension Surrogate Values
13-10 Error Handling
13-11 Preprocessing File Data Before Assigning to a Workspace Object
13-12 Maintaining Conjoint Dimensions with File Data
13-13 Reading Data From a Structured PRN File
13-14 Setting Paging for a Report
13-15 Varying Months
13-16 Additional Processing
13-17 Using the VALUE Keyword as a Function
13-18 Removing Extension From File Names
13-19 Finding the Starting Position of a Byte Group
13-20 Finding the Starting Position of a Character Group
13-21 Finding Two Sequential Lines
13-22 Calculating Interest
13-23 Displaying the Largest Integer Equal to or Less Than a Number
13-24 Using FOR in a DO Loop to Repeat ROW Commands
13-25 Using a FOR Statement for Looping Over Values
13-26 Using DO/DOEND in a FOR Loop
13-27 Using the EXPONENTIAL Method
13-28 Using the WINTERS Method
13-29 Report of Forecast Using the EXPONENTIAL Method
13-30 Report of Forecast Using the WINTERS Method
13-31 Calculating a Payment Schedule
13-32 Determining Monthly Payments
13-33 Listing the Properties of a Variable
14-1 Using GET to Obtain a Password
14-2 Using GOTO with IF
14-3 Finding the Longest Text Expressions
14-4 Finding the Largest Numerical Expression
14-5 Using GROUPINGID to Populate a Variable with Grouping Ids
14-6 Determining Growth Rate
14-7 Producing Column Headings
14-8 Hiding Program Text
14-9 Checking for Loops
14-10 Creating a Relational Representation of a Geography Hierarchy
14-11 Using HIERHEIGHT as a Simple Command
14-12 Using HIERHEIGHT After a FOR Statement
14-13 Using IF...THEN...ELSE
14-14 Using IF as a Conditional Operator
14-15 Importing Dimensions from an EIF File
14-16 IIMPORTING a Concat Dimension
14-17 Importing Columns Without the RULER Keyword
14-18 Importing Columns with the RULER Keyword
14-19 Importing a DIF File
15-1 Using INF_STOP_ON_ERROR with DBMS_EXECUTE
15-2 Reading the Input File Immediately
15-3 Getting Forecast Information
15-4 Getting Qualifier Information
15-5 Checking Qualifier Information
15-6 Checking Different Data Sources
15-7 Getting Parsed Information
15-8 Getting Regression Information
15-9 Comparing a List to a Master List
15-10 Inserting Bytes in Text
15-11 Inserting Characters in Text
15-12 Inserting Text Columns
15-13 Inserting Text Lines
15-14 Using INSTAT With a Valueset
15-15 Checking Current Status
15-16 Using INSTAT When the Dimension is a Conjoint Dimension
15-17 Using INSTAT When the Dimension is a Concat Dimension
15-18 Searching Forward for a String
15-19 Searching Backward for a String
15-20 Calculating the Integer Part of a Decimal Number
15-21 Calculating the Internal Rate of Return
15-22 Testing a Text Expression
15-23 Testing Valid Values
15-24 Testing Logical Position Numbers
15-25 Using JOINBYTES to Concatenate Values
15-26 Using JOINCHARS to Concatenate Values
15-27 Joining the Columns of Two Text Expressions
15-28 Joining the Lines of Two Text Expressions
15-29 Reporting with a Conjoint
15-30 Using LAG
15-31 Using LAGDIF and LAGABSPCT
15-32 Using LAGPCT
15-33 Finding the Largest Monthly Sales
15-34 Calculating Remaining Days in a Month
15-35 Setting Default Column Widths
15-36 Adding a Description to the Definition of a Variable
15-37 Using LEAD
15-38 Finding the Shortest Text Expressions
15-39 Finding the Smallest Numerical Expressions
15-40 The Effect of LIKECASE
15-41 Using an Escape Character with the LIKE Operator
15-42 Using an Escape Character with the LISTNAMES Program
16-1 The Effect of LIKENL
16-2 Adding and Removing Values
16-3 Limiting with a Dimension Surrogate
16-4 Limiting a Concat Dimension
16-5 Limiting with a Worksheet
16-6 Using Ampersand Substitution with LIMIT
16-7 Branching on Null Status
16-8 Limiting with a Literal Value
16-9 Limiting with a Boolean Expression
16-10 Limiting with a Formula
16-11 Limiting with a Valueset
16-12 Limiting with a Variable
16-13 Limiting a Conjoint Dimension with a Concat Base Dimension
16-14 Limiting to a Single Time Period of a Hierarchical Time Dimension
16-15 Limiting with a Related Dimension
16-16 A Simple Drill Down
16-17 Drilling Down Using SKIP and DEPT
16-18 Returning Multidimensional Results
16-19 LIMIT Command with the LIMIT Function
16-20 Retrieving the Name of a Dimension
16-21 Efficient Processing
16-22 Limiting with LIMITSTRICT Set to YES
16-23 Limiting with LIMITSTRICT Set to NO
16-24 Keeping the Heading Size Constant
16-25 Including a Footnote
16-26 Using LISTBY
16-27 Specifying More Than One Dimension
16-28 Listing Open Files
16-29 Listing of DEMO Workspace Objects
16-30 Loading Two Programs
16-31 Loading All the Programs in a Workspace
16-32 Explicitly Limiting a Language Dimension
16-33 Keeping a Log File
16-34 Calculating a Natural Logarithm
16-35 Calculating a Base 10 Logarithm
16-36 Converting Part of an Expression to Lowercase
16-37 Centering a Heading
16-38 Adding Values to a TEXT Dimension
16-39 Adding Values to a Conjoint Dimension
16-40 Adding Values to Dimension of Type QUARTER
16-41 Creating Calculated Dimension Members with Aggregated Values
16-42 Deleting Dimension Values by Value
16-43 Deleting the First Five Values of a Dimension
16-44 Deleting Dimension Values Based on a Boolean Expression
16-45 Deleting Dimension Values Using Surrogate to Specify Values
16-46 Deleting Related MONTH Values
16-47 Adding and Deleting Partition Values
16-48 Using the MERGE Keyword with Composites
16-49 Moving a Dimension Value to a Specific Position
16-50 Moving a Dimension Value to the End of the Status List
16-51 Moving Dimension Values into Sorted Order
16-52 Moving Values of Concat Dimensions
16-53 Specifying the Values of a Partition Using Valuesets
16-54 Renaming Values of a TEXT Dimension
16-55 Converting Integers to a Date
16-56 Calculating a Date Using YYOR, MMOF, and DDOF Functions
16-57 Calculating Whether Actual or Budget Values Are Larger
17-1 Finding the Length of the Longest Line Using Bytes
17-2 Finding the Length of the Longest Line Using Characters
17-3 Calculating Median Monthly Sales
17-4 Calculating Whether Actual or Budget Values Are Smaller
17-5 Finding the Current Month
17-6 Using the Default MODDAMP Value
17-7 Setting MODDAMP to Speed Up the Convergence of a Model
17-8 Reporting the Mode
17-9 Model Specified in a Program
17-10 Model from an Input File
17-11 Creating a Model
17-12 Building a Scenario Model
17-13 Simplified Model for Budget Estimates
17-14 Including a Model
17-15 Producing a Compilation Report
17-16 A Compilation Report for the income.budget Model
17-17 A Compilation Report for the income.est Model
17-18 Producing a Dependency Report
17-19 Producing an Execution Report for the income.est Model
17-20 Debugging a Model
17-21 Using the Default MODGAMMA Value
17-22 Setting MODGAMMA to Speed up the Convergence of a Model
17-23 Using the Default Order
17-24 Changing the MODINPUT Value
17-25 Model with MODMAXITERS
17-26 Using the Default MODOVERFLOW Value
17-27 Speeding Up the Divergence
17-28 Economizing on Memory Requirements
17-29 Using the Default MODTOLERANCE Value
17-30 Setting MODTOLERANCE to Speed Up the Convergence of a Model
17-31 Debugging a Model with MODTRACE
18-1 Collecting Timing Data Using MONITOR
18-2 Specifying Month Abbreviations
18-3 Specifying Two Sets of Month Names
18-4 Specifying English Month Names
18-5 Specifying French Month Names
18-6 Calculating the Number of Months Between Dates
18-7 Last Days
18-8 Moving a Relation
18-9 Calculating a Moving Average
18-10 Defining Multiple Paths in a Hierarchy
18-11 Filling NA Values with Zeros
18-12 Listing Dimensions
18-13 Listing Relations
18-14 The Effect of NASKIP on the TOTAL Function
18-15 The Effect of NASKIP on the MOVINGMIN Function
18-16 Effects of NASKIP and NASKIP2 When an Expression in an Aggregation Function Contains a Negative Values
18-17 Showing NA Values as "NONE"
18-18 Using the Current Time of day
18-19 Specifying the Time of day
18-20 Getting a Future Date
18-21 Changing Calendar Systems
18-22 Setting the Language for Dates
18-23 Checking the Current Value
18-24 Effects of Changing NLS_LANGUAGE
18-25 Changing the Decimal Marker to a Comma
18-26 Binary and Linguistic Sorts
18-27 Effects of Changing NLS_TERRITORY
18-28 Testing for No True Values by District
18-29 Testing for No True Values by Region
18-30 Showing Random Values
18-31 Seeing the Effect of the NOSPELL Option
18-32 Computing the Net Present Value
18-33 Counting the Bytes in the Longest Name
18-34 Counting the Characters in the Longest Name
18-35 Counting the Number of Lines
19-1 OBJ With ISBY
19-2 Getting Information about a Variable
19-3 Returning the Name of the Object or the Type of the Object
19-4 Using OBJ to Select Objects
19-5 Counting Compiled Objects
19-6 OBJ with REFERS
19-7 OBJ with PROPERTY
19-8 OBJ with SEGWIDTH
19-9 Listing Objects in Three Workspaces
19-10 Listing Referenced Objects
19-11 Using HASH
19-12 Using HIDE
19-13 Generating Text Data
19-14 Allowing Limits Within a Loop
19-15 Using OKNULLSTATUS
19-16 Sending a Report to an Output File
19-17 Directing Output to a File
19-18 Using OUTFILEUNIT with FILEQUERY
19-19 Keeping Lines Together
19-20 Forcing a Page Break
19-21 Changing the Heading for Page 2
19-22 Creating a Custom Heading
19-23 Using Program Arguments
19-24 Printing on Legal Paper
19-25 Setting Paging Options
19-26 Showing Negative Values in Parentheses
19-27 Parsing the Arguments to a Program
19-28 Calculating the Percentage
19-29 Variable Permission
19-30 Dimensioned Permission Condition
19-31 User-Defined Boolean Function
19-32 Individual Cells
19-33 Individual Dimension Values
19-34 Report Without Full Permission
19-35 Resetting Permission
19-36 Using FILEOPEN to Open a File
19-37 Viewing Progress in OLAP Worksheet
19-38 Tracing Program Execution
19-39 User-Defined Function with Arguments
19-40 Program On the Fly
19-41 Program from an Input File
19-42 Using OLAP Worksheet Instead of a PROGRAM Statement
19-43 Adding Properties to a Variable
19-44 Saving and Restoring Values
19-45 Creating Level Markers
19-46 Nesting PUSHLEVEL and POPLEVEL Commands
19-47 One-Step Restoration and Nested Levels
19-48 Using QUAL with MAX
19-49 Using QUAL with a Concat Dimension
20-1 Producing Random Numbers
20-2 Explicitly Seeding RANDOM for a Test
20-3 Ranking Values
20-4 Obtaining the Last Three Statements Containing "actual"
20-5 Using RECNO with FILEREAD
20-6 Redoing a Report
20-7 Editing Multiple Values in a LIMIT Command
20-8 Simple Regression
20-9 Weighted Regression
20-10 Report for a Simple Regression
20-11 Report for a Weighted Regression
20-12 Specifying a Default Relation Using the Relation Command
20-13 Two Users Modifying Different Objects in the Same Analytic Workspace
20-14 Using RELEASE After UPDATE But Before COMMIT
20-15 Calculating a Remainder
20-16 Using REMBYTES to Remove a Substring
20-17 Using REMCHARS to Remove a Substring
20-18 Removing a Single Character
20-19 Removing Text Columns
20-20 Removing Text Lines
20-21 Renaming a Program
20-22 Replacing Text as Bytes
20-23 How REPLBYTES Handles Line Breaks
20-24 Replacing Text Characters
20-25 How REPLCHARS Handles Line Breaks
20-26 Joining and Aligning Columns
20-27 Replacing a Text Line
20-28 Creating a Default Report
20-29 Including Column Totals
20-30 Comparing Two Variables
20-31 Repeating Price Data
20-32 Reporting Data Dimensioned by Composites
21-1 Determining If a Word Is Reserved
21-2 Resynchronizing Objects
21-3 Terminating a Program Early
21-4 Returning a Value
21-5 Using REVERT to Undo Modifications
21-6 Displaying a List of Groups or Roles
21-7 The Effect of ROOTOFNEGATIVE
21-8 Rounding to the Nearest Year
21-9 Rounding to Different Multiples
21-10 Rounding to the Nearest Thousand
21-11 Rounding to the Nearest Multiple of 12
21-12 Rounding to Decimal Places
21-13 Labeling Data Values
21-14 Reporting Two Variables
21-15 Formatting and Labeling the Output
21-16 Reporting on a Variable Dimensioned by a Composite
21-17 Assigning Output to a Text Variable
21-18 Producing Multiple Rows of Output
21-19 Calculating a Running Total in a Report
21-20 Calculating a Running Total over Two Districts
21-21 Timing a Program Using SECONDS
21-22 SESSION_NLS_LANGUAGE is a Session-Wide Option
21-23 Assigning Values to a Variable
21-24 Assigning Values to a Relation
21-25 Using a Qualified Data Reference
21-26 Assigning Values to Variables with Composites
21-27 Compacting Your Data
21-28 Showing the Value of an Option
21-29 Showing a Data Value
21-30 Creating Error Messages Using SHOW
21-31 Showing the Values of a Valueset
21-32 Signaling an Error
21-33 Signaling an Error When an Argument Value is Invalid
21-34 Calculating the Sine of an Angle in Radians
21-35 Calculating the Sine of an Angle in Degrees
21-36 Calculating the Hyperbolic Sine of an Angle
21-37 Suspending Program Execution
21-38 Finding the Month with the Least Amount of Sportswear Sales
21-39 Smoothing Values
21-40 Sorting Using a Relation as the Criterion
21-41 Sorting Based on a Concat
21-42 Sorting Based on a Component
21-43 Sorting by Hierarchy
21-44 Sorting Orphans of a Hierarchy
21-45 Sorting on a Composite
21-46 Sorting Text Lines
21-47 Using the HASH Algorithm
22-1 Inserting Data in a Table
22-2 Testing for the Value of SQLCODE
22-3 Discovering Information About Relational Tables
22-4 Discovering Information About the Columns of a Relational Table
22-5 Updating a Relational Table Using Analytic Workspace Data
22-6 Fetching Data From Relational Tables -- A Simple SQL FETCH
22-7 Fetching Data From Relational Tables with a THEN Clause
22-8 Populating with Relational Data While Maintaining a Conjoint Dimension
22-9 Populating Data While Maintaining Base and Conjoint Dimensions
22-10 Populating Variables with Relational Table Data while Maintaining Dimensions
22-11 Fetching Data into a Concat Dimension
22-12 Simple Import
22-13 Opening a Cursor Using SQL OPEN
22-14 Preparing a FOR Loop
22-15 Updating a Table
22-16 Using the WIDE Keyword
22-17 Creating a Stored Procedure
22-18 Executing a Stored Procedure
22-19 Simple select
22-20 Defining a Cursor with SQLBLOCKMAX
22-21 Using SQLCODE When Fetching Data
22-22 Displaying Error Messages
22-23 Sample Error Message
22-24 Calculating a Square Root
22-25 Finding the Fiscal Year Starting Date
22-26 Using STATALL
22-27 Assigning value of STATFIRST to Variables of Different Types
22-28 STATFIRST with KEEP
22-29 Setting Status with STATLAST
22-30 Counting Months in Status
22-31 Producing a Status List with ROW
22-32 Producing a Status List with SHOW
22-33 STATMAX Used in a Title
22-34 Using STATMIN in a Title
22-35 Comparing to STATFIRST
22-36 Using STATRANK to Identify Position Numbers
22-37 Using STATRANK When the Dimension Is a Conjoint Dimension
22-38 Using STATRANK When the Dimension Is a Concat Dimension
22-39 Discovering the Current Status of Certain Dimensions
22-40 Discovering the Status of the Dimensions of a Variable
22-41 STAVAL with Qualified Data References
22-42 Ensuring that STATVAL Returns an INTEGER
22-43 Changing NLS_LANGUAGE Without Changing the Language of the OLAP Session
23-1 Calculating the Standard Deviation of Monthly Sales
23-2 Creating a Custom Heading for a Report
23-3 Calculating Subtotals and Grand Totals in a Report
23-4 Multipath Branching Using SWITCH in a Program
23-5 Displaying the Current Date
23-6 Obtaining the User ID
23-7 Displaying the Platform
23-8 Breaking Out TALLY Results
23-9 Calculating the Tangent of an Angle
23-10 Calculating the Hyperbolic Tangent of an Angle
23-11 Splitting Data Across Quarters
23-12 Aggregating Weekly Data to Monthly Using TCONVERT
23-13 The Effects of TEXTFILL on ROW
23-14 Displaying the Decimal and Thousands Markers
23-15 Setting the Top Margin of a Report
23-16 Converting a Date to CHAR
23-17 Converting a Numerical Value to Text
23-18 Displaying the Current Date and Time in Spanish
23-19 Converting Text Values to DATE Values
23-20 Specifying a Default Language and a Date Format
23-21 Date Conversion
23-22 Converting Numerical Data to NTEXT Data
23-23 Specifying the Default Language and a Date Format
23-24 Converting Text Data to Decimal Data
23-25 Displaying the Current Time
23-26 Displaying Today's Date
23-27 Calculating a Date Using the TODAY Function
23-28 Totaling Sales over All Months
23-29 Setting POUTFILEUNIT to the Oracle Trace File
23-30 Collecting Timing Data USING TRCKPRG
23-31 Using the INIT Keyword and TRACKREPORT
24-1 Trapping a Program Error
24-2 Producing a Program Error Message Immediately
24-3 Producing a Program Error Message at the End of the Chain
24-4 Creating Triggers
24-5 Describing Triggers
24-6 Deleting Triggers
24-7 A MAINTAIN Trigger Program
24-8 An ASSIGN Trigger on a Variable
24-9 Setting Values in an ASSIGN Trigger Program
24-10 An ASSIGN Trigger on a Formula
24-11 TRIGGER_AFTER_UPDATE Program
24-12 TRIGGER_BEFORE_UPDATE Program
24-13 A TRIGGER_DEFINE Program
24-14 Assigning an Alternative Value using an Assign Trigger
24-15 Setting the Maximum Trigger Depth
24-16 Replacing NA Values Temporarily
24-17 Replacing NA Values Permanently
24-18 Truncating to the Nearest Year
24-19 Truncating to the Right of the Decimal Point
24-20 Truncating to the Left of the Decimal Point
24-21 Unhiding Program Text
24-22 Removing Duplicate Text Lines
24-23 Copying Data from a Worksheet to a Variable
24-24 Converting Part of a Text Expression to Uppercase
24-25 Saving Analytic Workspace Changes
24-26 Displaying the Session User ID
24-27 Changing USETRIGGERS to NO
24-28 Calculating the Number of Cells in a Page
24-29 Listing the Values of a Valueset
24-30 Listing Position Numbers of a Dimension
24-31 VALUES with Text Variables
24-32 Workaround for Dimension Value Names Including an Ampersand
24-33 Saving a File Unit Number
24-34 Returning a Dimension Value from a Program
24-35 Using VINTSCHED
24-36 Assigning a VNF for a Dimension of Type MONTH
24-37 Adding Values to a Dimension of Type Month
24-38 Assigning a VNF for WEEK
24-39 Using VPMTSCHED
24-40 Finding Today's Week
24-41 Finding the Week of a Date
24-42 Using a WHILE Loop in a Program
24-43 Grouping Values Into a Ten-Bucket Histogram
24-44 Checking Data Imported from a Worksheet
24-45 Seeing the Effect of the YESSPELL Value
24-46 Using the Default Value
24-47 Setting the 100-Year Period for a Date
24-48 Obtaining the Current Year
24-49 Suppressing Report Rows of All-Zero Data
24-50 Resetting All Report Column Subtotals
24-51 Showing Zero Values as NONE
24-52 Showing Very Small Numbers
