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
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.
CachedRowSet Constraints → the row set since the properties cannot be applied to the connection after retrieving the data from
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
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
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
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
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
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 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 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 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 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
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-Level Dependency Tracking → … ROWDEPENDENCIES specifies that the SCN is tracked for each row in the table. Using the ROWDEPENDENCIES … requires six bytes of additional storage space for each row. The following SQL statement creates a … ) ) ROWDEPENDENCIES; Oracle tracks the SCN for each row in this order_items table. You can also use the
Special Row Label Privileges → Once the label on a row has been set, Oracle Label Security privileges are required to modify the … a row label, the new label and old label are compared, and the required privileges are determined … . WRITEUP The WRITEUP privilege enables the user to raise the level of data within a row, without … authorized level. For example,
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
Single-Row Functions → Single-row functions return a single result row for every row of a queried table or view. These
Continued Row Ratio → This ratio should be very close to zero, except in applications handling long LONG columns. If this ratio increases over time, usually PCTFREE has been set too low on one or more tables. oraDbSysTableFetchContinuedRow / (oraDbSysTable FetchRowid + oraDbSysTableScanRows)
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