How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Contents → Skip Headers Oracle9 i OLAP Developer's Guide to the OLAP API Release 2 (9.2) Part Number A95297-01 … Introduction to the OLAP API OLAP API Overview Multidimensional Concepts And the OLAP API What Type … API? Context for OLAP API development Access to Data and Metadata Through the OLAP API MDM Model in … the OLAP API Access to
Oracle9i OLAP Developer's Guide to the OLAP DML -- Contents → … Analytic Workspaces SQL and the OLAP DML The OLAP API and the OLAP DML Using the OLAP DML How to Use … the OLAP DML to Analyze Data Creating an Analytic Workspace Loading Data Into Analytic Workspaces … from OLAP Worksheet Procedures: How to Open OLAP Worksheet Establishing a Connection Executing … Analytic Workspaces
Pro*PL/I Supplement to the Oracle Precompilers Guide -- Contents → VARYINGReturning Nulls to a CHARACTER (N) Handling Character Data Effects of the MODE Option The Oracle Datatypes … SQLCHECK Connecting to Oracle Automatic Logins Concurrent Logins 2 Error Handling and Diagnostics
Programmer's Guide to the Oracle Precompilers Release 7.3 → Programmer's Guide to the Oracle ® Precompilers Preface What This Guide Has to Offer Who Should
Pro*FORTRAN Supplement to the Oracle Precompilers Guide Release 7.3 → Pro*FORTRAN ® Supplement to the Oracle ® Precompilers Guide Preface What This Manual Has to Offer … Embedding PL/SQL Cursor Variables Connecting to Oracle Error Handling and Diagnostics Error Handling
A Program Example Sample Tables Meeting Program Requirements The Declare Section INCLUDE Statements… → Character Sets Connecting to Oracle Concurrent Logons Embedding OCI (Oracle Call Interface) Calls … How to Begin and End Transactions Using the COMMIT Statement Using the ROLLBACK Statement Using the … Dynamic SQL What Is Dynamic SQL? Advantages and Disadvantages of Dynamic SQL When to Use Dynamic SQL … ? Developing a User Exit
Simple Blocks → Simple blocks include equations that are independent of each other and equations that have dependencies on each other that are noncyclic. If a block contains equations that solve for values A, B, and C, then a noncyclic dependence can be illustrated as shown below where the arrows indicate that A depends on B, and B depends on C. Text description of the illustration modsimp.gif
Workspace Aliases → alias with the AW ALIASLIST command. An alias is in effect from the time it is assigned to the time … unattached workspace, you must reassign its aliases. One reason for assigning an alias is to have a … short way to reference a workspace that belongs to a schema that is not yours. For example, you can use … assigning
How to Use the OLAP DML to Analyze Data → To use the OLAP DML, you: Create an analytic workspace. Define data objects within the analytic … use the OLAP DML to analyze data, you can then: View data in an analytic workspace using the OLAP API or SQL. Write data to SQL tables.
Sharing Data In Analytic Workspaces → Data in analytic workspaces may be shared by many different users. To share data in an analytic … workspace, the workspace needs to be persisted during the period of time it is to be shared. For … example, if you want to allow a user to share the results of a forecast, you can allow the user to
Adding New Dimension Values from a Data File → values and all the associated data to the analytic workspace by using the APPEND attribute in the … in the dr.prog2 program uses APPEND to add any new productid values to the analytic workspace. The … second FILEREAD command includes a field to read the product name so the new data will be complete … . The error
Using the HFIRST and HLAST Operators → Use the HFIRST and HLAST operators when you want to allocate data to the first or last child of a … data from the actual variable to the budget variable and then allocates the data from the budget cell … specified by a parent time value to one specified by a child time value. The actual and budget … values of
Arguments in a User-Defined Function → … However, if you supply an argument to a user-defined function in a context that loops over a … product units that are expected to be sold. Suppose also that you define a program named … number of units that were actually sold for that cell. The program returns a Boolean value to the … calling program. It returns YES
Arithmetic Operators → a numeric expression, the expression is evaluated according to standard rules of arithmetic. The … priority are evaluated from left to right. Table 4-2 Arithmetic Operators Operator Operation
Automatic Conversion of Numeric Data Types → Numbers are converted to different data types according to the following rules. IF you . . . THEN … converted to its long counterpart before using it. Note: See "Boolean Expressions" for information … the result is outside the range of a SHORTINTEGER (-32768 to 32767). assign the value of a DECIMAL … expression
Formatting Guidelines for Editing Programs → Use the following formatting guidelines as you add lines to your program: Each line of code can … have a maximum of 4000 bytes. To continue a single command on the next line, place a hyphen ( - ) at … the end of the line to be broken. The hyphen is called a continuation character. You cannot use a … continuation character in the
Effects of Dimension Status → quarters are NA. This can be useful when you want to aggregate just the new data in your analytic
Executing a stored procedure → You use a PROCEDURE statement to run a stored procedure, using the following syntax. SQL PROCEDURE … . When you use input host variables, be sure to use a colon before the variable name. Also be sure to … uses the new_product s procedure to insert a single row in the products table, or you can specify … " illustrates
Creating Boolean Expressions → A Boolean expression is a three-part clause that consists of two items to be compared, separated by … parentheses around the expression, to reverse the sense of a Boolean expression. The following two … were greater than a literal amount. LIMIT time TO FIRST 2 LIMIT geography TO 'BOSTON' REPORT DOWN