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
set() → This method sets the interval to the values specified. Syntax void set(int day, int hour, int
set() → This method sets the interval to the values specified. Syntax void set(int year, int month
SET → Purpose Use the SET command to alter the parameter values for the Oracle Names server. These … SAVE_CONFIG, SET SAVE_CONFIG_ON_STOP, or SET SAVE_CONFIG_INTERVAL commands to save changes to the names.ora file.
SET → Purpose Use the SET command to alter the parameter values for the listener. Parameter values
SET → Purpose Use the SET command to alter the parameter values for the Oracle Connection Manager
Set → s the 8-byte CURRENCY number. Syntax public void Set(long value) Where Is value the 8-byte CURRENCY
SET → Syntax Text description of the illustration set.gif set_rman_option::= Text description of the illustration set_rman_option.gif set_run_option::= Text description of the illustration set_run_option.gif
SET → set system variables. SET system_variable value where system_variable and value are shown in the SET commands following.
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 … the row set rowsetChanged event: Generated when the whole row set is created or changed The following … code shows
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
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 … with a query, complete the following steps: Instantiate OracleCachedRowSet. Set
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 … CLASSPATH For Windows 2000/NT/98/95, the command is: set CLASSPATH=%CLASSPATH%;%ORACLE_HOME%\jdbc\lib … \ocrs12.zip This might also
CachedRowSet Constraints → All the constraints which apply to updatable result set are applicable here, except serialization … data is cached in memory. Properties which apply to the connection cannot be set after populating … the row set since the properties cannot be applied to the connection after retrieving the data from … the same like, transaction
Runtime Properties for Row Set → Typically, static properties for the applications can be set for a row set at the development time … and the rest of the properties which are dynamic (are dependent on runtime) can be set at the … , concurrency type of the row set, or the query itself. The runtime properties, like the bind parameters for
Traversing Through the Rows → way to implement a scrolling and updatable result set if they are not provided by the result set
JDBC Row Set → A JDBC row set is another row set implementation. It is a simple, non-serializable connected row … set which provides JDBC interfaces in the form of a Bean interface. Any call to JDBCRowSet percolates … directly to the JDBC interface. The usage of the JDBC interface is the same as any other row set … Cached Yes
2 Choosing a Character Set → This chapter explains how to choose a character set. It includes the following topics: Character … Set Encoding Length Semantics Choosing an Oracle Database Character Set Changing the Character Set
How are Characters Encoded? → Different types of encoding schemes have been created by the computer industry. The character set … database schema and application development. The character set you choose uses one of the following types
Changing the Character Set After Database Creation → You may wish to change the database character set after the database has been created. For example … character set. However, if, and only if, the new character set is a strict superset of the current character … set, it is possible to use the ALTER DATABASE CHARACTER SET statement to expedite the change
Multilingual Database Scenarios → Multilingual support can be restricted or unrestricted. This section contains the following topics: Restricted Multilingual Support Unrestricted Multilingual Support
Restricted Multilingual Support → … For example, the WE8ISO8859P1 Oracle character set supports the following Western European … Spanish Swedish These languages all use a Latin-based writing script. When you use a character set that … Western European server that used the WE8ISO8850P1 Oracle character set, a French client that uses … the same character
PROCESS Character Set Scanner Parameter → Default value: 1 Minimum value: 1 Maximum value: 32 Purpose: Specifies the number of concurrent scan processes to utilize for the database scan
SUPPRESS Character Set Scanner Parameter → Set Scanner inserts individual exceptional record information into the CSM$ERRORS table when an … number of exceptions are inserted for each table. For example, if SUPPRESS is set to 100, then the … Character Set Scanner records a maximum of 100 exception records for each table. See Also: "Storage Considerations"
Examples: Character Set Scanner Sessions → The following examples show you how to use the command-line and parameter-file methods to use Full Database, User, and Table scan modes.
Individual Exception Report → database Scan CHAR data? YES Current database character set we8mswin1252 New database character set utf8 … must be corrected before migrating to the new character set, or else the invalid characters will be … report that illustrates some possible problems when changing the database character set from … SET
Performance Considerations → number of scan processes to use is to set the number equal to the CPU_COUNT initialization parameter … . Array Fetch Buffer Size The Character Set Scanner fetches multiple rows at a time when an array fetch … is allowed. Generally, you will improve performance by letting the Character Set Scanner use a … Convertible Log The Character
Data Truncation → allows 20 bytes for storing character data. This is acceptable when the database character set uses a … of bytes. If the database character set uses a multibyte character encoding scheme, then the number … bytes. During migration to a new character set, it is important to verify the column widths of … CHAR and VARCHAR2 datatypes
Migrating to the Oracle9 i NCHAR Datatypes → Unicode encoding regardless of the database character set. This allows users to store Unicode in a … database that does not use Unicode as the database character set. This section includes the following … topics: Migrating Oracle8 NCHAR Columns to Oracle9i Changing the National Character Set Migrating CHAR Columns to NCHAR Columns in
13 Result Set Enhancements → Standard JDBC 2.0 features in JDK 1.2.x include enhancements to result set functionality … internally or externally, and updating result set data and then copying the changes to the database … Methods for Result Set Enhancements The Oracle JDBC drivers also include extensions to support these … set enhancements,
Overview → This section provides an overview of JDBC 2.0 result set functionality and categories, and some
Processing a Scrollable Result Set → In a scrollable result set you can iterate backward instead of forward as you process the result … set. The following methods are available: boolean next() throws SQLException boolean previous() throws … first row). Backward versus Forward Processing You can process the entire result set going forward … , using the next() method
Updating Result Sets → A concurrency type of CONCUR_UPDATABLE allows you to update rows in the result set, delete rows … from the result set, or insert rows into the result set. After you perform an UPDATE or INSERT … operation in a result set, you propagate the changes to the database in a separate step that you can skip if … you want
Summary of Visibility of Internal and External Changes → Table 13-1 summarizes the discussion in the preceding sections regarding whether a result set … object in the Oracle JDBC implementation can see changes made internally through the result set itself … Result Set Type Can See Internal DELETE? Can See Internal UPDATE? Can See Internal INSERT? Can See … external changes are "visible",
Character Set Encoding → sets. This section includes the following topics: What is an Encoded Character Set? Which Characters … Are Encoded? What Characters Does a Character Set Support? How are Characters Encoded? Naming Convention for Oracle Character Sets
Current and Future Language Requirements → requirements when you choose a database character set. If you expect to support additional languages in … the future, then choose a character set that supports those languages to prevent the need to migrate to a different character set later.
Access Privileges → To use the Character Set Scanner, you must have DBA privileges on the Oracle database.
Scan Modes in the Character Set Scanner → The Character Set Scanner provides three modes of database scan: Full Database Scan User Scan Table Scan
Full Database Scan → The Character Set Scanner reads and verifies the character data of all tables belonging to all … simulated migration to the new database character set. It scans all schema objects including stored … new database character set, you need to perform a full database scan.
Getting Online Help for the Character Set Scanner → The Character Set Scanner provides online help. Enter csscan help=y on the command line to invoke … the help screen. You can let the Character Set Scanner prompt you for parameters by entering the … , you can control how the Character Set Scanner runs by entering the CSSCAN command followed by … =utf8 ARRAY=102400 PROCESS=3 The