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 47005 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Developer's Guide to the OLAP API, 10g Release 1 (10.1)

Contents

ContentsStructure Related Documents Conventions 1 Introduction to the OLAP API 1.1 OLAP API Overview 1.1.1 … Development 1.2 Sample Schema for OLAP API Examples 1.3 Access to Data and Metadata Through the OLAP API … 1.3.1 MDM Model in the OLAP API 1.3.2 Access to Data Through the OLAP API 1.3.3 Unique and Local … : Connect to

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Contents

ContentsConnecting to Oracle 2 Error Handling and Diagnostics Error Handling Alternatives Using Status

Pro*PL/1® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Contents

ContentsVariables 1.7 CHARACTER VARYING 1.7.1 VARYINGReturning Nulls to a CHARACTER (N) 1.8 Handling … Truncated Values 1.12.3 SQLCHECK 1.13 Connecting to Oracle 1.13.1 Automatic Logins 1.13.2 Concurrent

Release 1.8, 10g Release 1 (10.1)

Meeting Program Requirements

VARCHAR Variablescan use the VARCHAR pseudotype to declare variable-length character strings. (A pseudotype is a … datatype not native to your host language.) Recall that VARCHAR variables have a 2-byte length field

Release 1.8, 10g Release 1 (10.1)

Meeting Program Requirements

Indicator Variablesspaces, a single double-byte space is left in the buffer to act as a sentinel. Output host variables … trailing double-byte spaces. The length component is assumed to be the length of the data in characters … to the length of the data in characters, not bytes. STRING / LONG VARCHAR. These host variables are

Release 1.8, 10g Release 1 (10.1)

Using Dynamic SQL

Using Method 3CONNECT:username IDENTIFIED BY:password; display 'Connected to Oracle'; set sql_stmt = 'INSERT INTO EMP … WORK RELEASE; exit program with an error; Using Method 3 Method 3 is similar to Method 2 but combines … the PREPARE statement with the statements needed to define and manipulate a cursor. This allows your … program to

Release 1.8, 10g Release 1 (10.1)

Defining and Controlling Transactions

Using the SAVEPOINT Statementit to make sure it follows syntax rules and refers to valid database objects. Errors detected while … . Oracle can also roll back single SQL statements to break deadlocks. Oracle signals an error to one … the SAVEPOINT Statement You use the SAVEPOINT statement to mark and name the current point in the

Release 1.8, 10g Release 1 (10.1)

Performance Tuning

Eliminating Unnecessary Parsingapplication relies on table-level locking, modify it to take advantage of row-level locking. In general

Release 1.8, 10g Release 1 (10.1)

Running the Oracle Precompilers

LRECLENNotes Cannot be entered inline. By default, the listing file is written to the current directory

Release 1.8, 10g Release 1 (10.1)

Running the Oracle Precompilers

UNSAFE_NULLPurpose Specifying UNSAFE_NULL=YES prevents generation of ORA-01405 messages when fetching NULLs without using indicator variables.

Release 1.8, 10g Release 1 (10.1)

Running the Oracle Precompilers

Compiling and Linkinglocal SQL statements. Compiling and Linking To get an executable program, you must compile the source … from SQLLIB and system-specific Oracle libraries. Also, if you are embedding OCI calls, make sure to … modules. If these references conflict, the link fails. This can happen when you try to link third party … might have problems.

Release 1.8, 10g Release 1 (10.1)

Using Embedded SQL

Opening a Cursorprecompilation unit to another. Also, cursor names cannot be hyphenated. They can be any length, but only … referencing the cursor. That is, forward references to the cursor are not allowed. In the following … many cursors, you might want to specify the MAXOPENCURSORS option. For more information about … MAXOPENCURSORS, see page

Release 1.8, 10g Release 1 (10.1)

Using Embedded SQL

A Complete Examplereturns the "no data found" Oracle warning code to SQLCODE in the SQLCA. The cumulative number of rows … EXEC SQL WHENEVER SQLERROR DO sql_error; -- log on to Oracle EXEC SQL CONNECT:username IDENTIFIED BY … :password; display 'Connected to Oracle'; -- declare a cursor EXEC SQL DECLARE emp_cursor CURSOR

Release 1.8, 10g Release 1 (10.1)

Learning the Basics

Steps in Developing an Embedded SQL Applicationstatement, the Oracle Server returns a status code to a variable named SQLCODE or SQLSTATE. The status … Oracle to pass runtime status information to the program. With the SQLCA, you can take different … actions based on feedback from Oracle about work just attempted. For example, you can check to see if … can

Release 1.8, 10g Release 1 (10.1)

Running the Oracle Precompilers

MODESyntax MAXOPENCURSORS= integer Default 10 Usage Notes You can use MAXOPENCURSORS to improve the … tries to reuse an entry. Its success depends on the values of HOLD_CURSOR and RELEASE_CURSOR, and, for … it cannot find one to reuse. If necessary, Oracle keeps allocating additional cache entries until … it runs out of memory or

Release 1.8, 10g Release 1 (10.1)

Embedded SQL Commands and Directives

DECLARE STATEMENT (Embedded SQL Directive)Purpose To declare an identifier for a SQL statement or PL/SQL block to be used in other embedded SQL statements.

Release 1.8, 10g Release 1 (10.1)

Using Host Arrays

Restrictionsstatement are limited to one dimension. So, the two-dimensional array declared in the following example is invalid:

Release 1.8, 10g Release 1 (10.1)

Oracle Reserved Words, Keywords, and Namespaces

Namespace LibraryO OCI functions S function names from SQLLIB and system-dependent libraries XA external functions for XA applications only GEN KP L NA NC ND NL NM NR NS NT NZ TTC UPI Internal functions Table B - 1. Oracle Reserved Namespaces

Release 1.8, 10g Release 1 (10.1)

Using Dynamic SQL

OPENEXEC SQL DECLARE emp_cursor CURSOR FOR sql_stmt; The identifiers sql_stmt and emp_cursor are not host or program variables, but must be unique. If you declare two cursors using the same statement name, the precompiler considers the two cursor names synonymous. For example, if you execute the statements EXEC SQL PREPARE sql_stmt FROM:select_stmt; EXEC SQL DECLARE emp_cursor FOR sql_stmt; EXEC SQL PREPARE