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


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

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

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)

Selecting Data, 7 of 13

Limiting Using Value Position in an Unrelated DimensionYou can use the LIMIT command with the NOCONVERT keyword to insert a value into a dimension status … , when there is a one-to-one correspondence between the product dimension in two analytic workspaces … ). The simplified syntax for using the LIMIT command in this way is shown below: LIMIT dimension TO … related to

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

Selecting Data, 12 of 13

Errors When Limiting Status to a Null ValueAn error will not be signaled when you try to limit the status of a dimension or valueset that has … any values to a newly defined dimension WEEK, then the following command does not cause an error … . LIMIT week TO FIRST 10 However, the following command does cause an error because PETE is not a value … . LIMIT week TO

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

Working with Relational Tables, 3 of 7

Process: Writing Programs that Populate Analytic Workspaces with Relational DataTo populate the analytic workspace structures with data from relational tables, you write and

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

Basic Concepts, 4 of 6

Establishing a ConnectionTake these steps to establish a connection to Oracle OLAP: From the OLAP Worksheet menu bar, choose … Server. Choose Connect. You see the Login to Database box. Enter valid database user credentials … :rel9i. Oracle controls your access to data on the basis of your database user ID. Your user ID must … have access

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

Defining and Working with Analytic Workspaces, 5 of 9

Effect of the ROLLBACK CommandThe OLAP DML does not provide a way to issue a ROLLBACK command; however, you could execute one in … executed in your session, Oracle OLAP checks to see whether there are uncommitted updates in an attached … action in response to the ROLLBACK command. This means that, if you have not issued an UPDATE command … workspace during

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

Reading Data from Files, 8 of 9

Processing Records Individuallyor more distinct types of records mixed together in a single file. You might even have to decide … what to do with the data in a record based on the contents of one or more of its fields. The FILENEXT … function and the FILEVIEW command allow you to retrieve one record at a time from a file and look at … by FILENEXT is then available

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

Introduction to Querying, 3 of 3

Creating Simple Nondimensional Source ObjectscreateRangeSource methods on the DataProvider class. These Source objects are sometimes referred to … a Source with a single value of 4. To create this Source you issue the code shown in Example 5-3

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

Understanding OLAP API Metadata, 5 of 11

MdmDimension ClassSkip Headers Oracle9 i OLAP Developer's Guide to the OLAP API Release 2 (9.2) Part Number A95297-01 … are within the MdmHierarchy, they correspond to elements in MdmLevel objects. Therefore, loosely … the MdmDimension to values representing some characteristic of the elements. To obtain the … about the MdmDimension

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

Understanding Cursor Classes and Concepts, 5 of 6

What is the Extent of a Cursor?The extent of a Cursor is the total number of elements it contains relative to any slower varying … to the value of its slower varying output. The child Cursor objects are layered horizontally with the … example, to display the correct number of columns or correctly-sized scroll bars. The extent, however … , can be expensive to

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

Introduction to the OLAP API, 2 of 6

OLAP API OverviewSkip Headers Oracle9 i OLAP Developer's Guide to the OLAP API Release 2 (9.2) Part Number A95297-01 … Home Book List Contents Index Master Index Feedback Introduction to the OLAP API, 2 of 6 OLAP API … OLAP, an Oracle component. The purpose of the OLAP API is to facilitate the development of OLAP … applications, which allow users

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 Relational Tables, 3 of 7

Importing and Fetching Relational Table Data into Analytic Workspace ObjectsAfter you open a cursor, you can use a SQL IMPORT or a SQL FETCH command statement to copy data … you have access rights to the tables that you want to use. SQL IMPORT or a SQL FETCH both copy data … and assigns the retrieved data to OLAP objects. When you use a FETCH statement to retrieve data

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

Selecting Data, 6 of 13

Suppressing the Sort When Limiting to a Related DimensionThe LIMIT.SORTREL option controls whether or not a sort is done when you limit a dimension to a … related dimension. You can suppress the sort that occurs when you limit a dimension to a related … dimension by setting LIMIT.SORTREL to no. This can significantly improve performance when the dimension