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 ROW

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

Utilities, 9i Release 2 (


Row ErrorsIf a row is rejected due to an integrity constraint violation or invalid data, Import displays a … RESUMABLE=y parameter is specified. Failed Integrity Constraints A row error is generated if a row violates … Concepts Invalid Data Row errors can also occur when the column definition for a table in a database is

SQLJ Developer's Guide and Reference, 9i Release 2 (

Performance and Debugging

Row PrefetchingStandard JDBC receives the results of a query one row at a time, with each row requiring a separate … round trip to the database. Row prefetching allows you to receive the results more efficiently, in … value as follows: ((Connection)ctx.getConnection()).setDefaultRowPrefetch(20); There is no maximum row

Advanced Replication, 9i Release 2 (

Deployment Templates Concepts and Architecture

Row SubsettingRow subsetting enables you to exclude rows that are in master tables from materialized views by … other than 173 are excluded from this materialized view. Row Subsetting with an Assignment Table

Concepts, 9i Release 2 (

Introduction to Real Application Clusters

Row LockingOracle row locking and multi-version read consistency provide a high degree of concurrency and … throughput. Row locking ensures that transactions that modify different rows in the same data block do … not need to wait for each other to commit. See Also: Oracle9i Database Concepts for more information about row locking

Streams, 9i Release 2 (

Streams Capture Process

Row LCRsA row LCR describes a change to the data in a single row or a change to a single LOB column in a … row. The change results from a data manipulation language (DML) statement or a piecewise update to a … multiple row LCRs. That is, a capture process creates an LCR for each row that is changed by the DML

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

A Row SetThis appendix describes the following topics: Row Set Setup and Configuration Runtime Properties … for Row Set Row Set Listener Traversing Through the Rows Cached Row Set JDBC Row Set

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

Row Set ListenerThe row set feature supports multiple listeners to be registered with the RowSet object. Listeners … as the row set listener. Three types of events are supported by the RowSet interface: cursorMoved … () methods are called rowChanged event: Generated when a new row is inserted, updated, or deleted from … the row

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

IntroductionA row set is an object which encapsulates a set of rows. These rows are accessible though the … is part of JDBC optional package by JavaSoft. Three kinds of row set are supported by JavaSoft … : Cached row set JDBC row set Web row set Note: Oracle implements cached row set and JDBC row

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

Cached Row SetA cached row set is a row set implementation where the rows are cached and the row set does not … , password, and the SQL query for the row set is set as properties. The RowSet object is populated through … populate() method of the cached row set to populate the contents of the result set into cached

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

Row Set Setup and ConfigurationThe classes for the row set feature are found in a separate archive, This file is … located in the $ORACLE_HOME/jdbc directory. To use row set, you need to include this archive in your … Jdeveloper. Oracle row set interfaces are implemented in the oracle.jdbc.rowset package. Import this … package to use any of the

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

CachedRowSet Constraintsthe row set since the properties cannot be applied to the connection after retrieving the data from

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

Runtime Properties for Row SetTypically, static properties for the applications can be set for a row set at the development time … , concurrency type of the row set, or the query itself. The runtime properties, like the bind parameters for

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

Traversing Through the RowsVarious methods to traverse through the rows are provided by the RowSet interface. These properties are inherited directly from the java.sql.ResultSet interface. The RowSet interface could be used as a ResultSet interface for retrieval and updating of data. The RowSet interface provides an optional way to implement a scrolling and updatable result set if they are not provided by the result set implementation.

JDBC Developer's Guide and Reference, 9i Release 2 (

Row Set

JDBC Row SetA JDBC row set is another row set implementation. It is a simple, non-serializable connected row … directly to the JDBC interface. The usage of the JDBC interface is the same as any other row set … A-1 The JDBC and Cached Row Sets Compared   RowSet Type Serializable Connected to Database Movable

Performance Tuning Guide and Reference, 9i Release 2 (

Dynamic Performance Views for Tuning

TX: Row Transaction Lockcontaining the row(s) to be changed does not have any ITL (interested transaction list) entries left … Request/Lmode 0: None 2: Row Share: used for shared DML locks 4: Share: used for shared TX when … waiting for ITL entry 6: Exclusive used for row level, DML locks Any row in V$LOCK either has LMODE=0 … (type

Application Developer's Guide - Fundamentals, 9i Release 2 (

How Oracle Processes SQL Statements

Explicitly Acquiring Row Locksstatement acquires exclusive row locks for selected rows (as an UPDATE statement does), in … statement to lock a row without actually changing it. For example, several triggers in Chapter 15 … "Foreign Key Trigger for Child Table"), the row that contains the referenced parent key value is locked to … some time); row

Data Cartridge Developer's Guide, 9i Release 2 (

Design Considerations

Multi-Row FetchODCIIndexFetch(self IN [OUT], nrows IN NUMBER, rids OUT ODCIRidList) RETURN NUMBER When the ODCIIndexFetch routine is called, the ROWID s of all the rows that satisfy the operator predicate are returned. The maximum number of rows that can be returned by the ODCIIndexFetch routine is nrows ( nrows being an argument to the ODCIIndexFetch routine). The value of nrows is decided by Oracle based on some

Deployment and Performance, 9i Release 2 (

Monitoring Performance in Real Application Clusters with Oracle Performance Manager

Row Cache Lock ChartThe Row Cache Lock chart displays the following statistics for the entire cluster database: The … to the Row Cache Lock By Instance chart. The statistics on this chart highlight any dictionary

SNMP Support Reference Guide, 9i Release 2 (

Designing Management Applications Based on Oracle MIBs

Row Source RatioThis ratio measures the percentage of the total rows retrieved which came from full table scans. As soon as this percentage starts to rise much above 0, the interpretation of other statistics may need to be reviewed. oraDbSysTableScanRows / (oraDbSysTableFetchRowid + oraDbSysTableScanRows)

interMedia User's Guide and Reference, 9i Release 2 (

interMedia Examples

3.3.7 Querying a RowExample 3-31 and Example 3-32 assume you have this table: CREATE TABLE stockphotos ( photo_id NUMBER, photographer VARCHAR2(64), annotation VARCHAR2(255), photo ORDSYS.ORDImage, photo_sig ORDSYS.ORDImageSignature); Example 3-31 queries the stockphotos table for the photo_id of 1 and the ORDImage data for rows with minimum photo widths (greater than 32 pixels).You must create a table alias (E in this