You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for TO


1 to 20 of 46659 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


OLAP Developer's Guide to the OLAP API, 9i Release 2 (9.2.0.2)

Oracle9i OLAP Developer's Guide to the OLAP API -- Contents

ContentsSkip 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Oracle9i OLAP Developer's Guide to the OLAP DML -- Contents

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, 9i Release 2 (9.2.0.2)

Pro*PL/I Supplement to the Oracle Precompilers Guide -- Contents

Pro*PL/I Supplement to the Oracle Precompilers Guide -- ContentsVARYINGReturning 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 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Table of Contents

Programmer's Guide to the Oracle Precompilers Release 7.3Programmer's Guide to the Oracle ® Precompilers Preface What This Guide Has to Offer Who Should

Pro*Fortran Supplement to the Oracle Precompilers Go To Documentation Library, 9i Release 2 (9.2.0.2)

Table of Contents

Pro*FORTRAN Supplement to the Oracle Precompilers Guide Release 7.3Pro*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

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Table of Contents

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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Models, 5 of 8

Simple BlocksSimple 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Defining and Working with Analytic Workspaces, 4 of 9

Workspace Aliasesalias 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Basic Concepts, 3 of 6

How to Use the OLAP DML to Analyze DataTo 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.

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Basic Concepts, 3 of 6

Sharing Data In Analytic WorkspacesData 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Reading Data from Files, 6 of 9

Adding New Dimension Values from a Data Filevalues 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Allocating Data, 5 of 5

Using the HFIRST and HLAST OperatorsUse 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Developing Programs, 6 of 12

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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Expressions, 6 of 11

Arithmetic Operatorsa 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Expressions, 6 of 11

Automatic Conversion of Numeric Data TypesNumbers 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Developing Programs, 3 of 12

Formatting Guidelines for Editing ProgramsUse 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Aggregating Data, 7 of 12

Effects of Dimension Statusquarters are NA. This can be useful when you want to aggregate just the new data in your analytic

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Relational Tables, 6 of 7

Executing a stored procedureYou 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Expressions, 8 of 11

Creating Boolean ExpressionsA 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

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Working with Expressions, 8 of 11

Comparing Dateswhether today is 60 or more days after the billing date in order to send out a more strongly worded bill … functions to change dates to integers and integers to dates for comparison.