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
A Row Set → This 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
Row Set Listener → The 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
Introduction → A 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
Cached Row Set → A 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
Row Set Setup and Configuration → The classes for the row set feature are found in a separate archive, ocrs12.zip. 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
CachedRowSet Constraints → the row set since the properties cannot be applied to the connection after retrieving the data from
Runtime Properties for Row Set → Typically, 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
Traversing Through the Rows → Various 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 Row Set → A 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
Row Errors → If 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
Row Prefetching → Standard 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
Row Subsetting → Row 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
Row Locking → Oracle 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
Row LCRs → A 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
TX: Row Transaction Lock → containing 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
Explicitly Acquiring Row Locks → statement 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
Multi-Row Fetch → ODCIIndexFetch(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
Row Cache Lock Chart → The 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
Row Source Ratio → This 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)
3.3.7 Querying a Row → Example 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