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 SET


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


Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 10 of 22

set()This method sets the interval to the values specified. Syntax void set(int day, int hour, int

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 11 of 22

set()This method sets the interval to the values specified. Syntax void set(int year, int month

Net Services Reference Guide, 9i Release 2 (9.2.0.2)

Oracle Names Control Utility

SETPurpose 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.

Net Services Reference Guide, 9i Release 2 (9.2.0.2)

Listener Control Utility

SETPurpose Use the SET command to alter the parameter values for the listener. Parameter values

Net Services Reference Guide, 9i Release 2 (9.2.0.2)

Oracle Connection Manager Control Utility

SETPurpose Use the SET command to alter the parameter values for the Oracle Connection Manager

Developer's Guide, 9i Release 2 (9.2.0.2)

Oracle COM Automation Feature Core Functionality

Sets the 8-byte CURRENCY number. Syntax public void Set(long value) Where Is value the 8-byte CURRENCY

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 50 of 59

SETSyntax 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

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Command Reference

SETset system variables. SET system_variable value where system_variable and value are shown in the SET commands following.

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.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 (9.2.0.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 … the row set rowsetChanged event: Generated when the whole row set is created or changed The following … code shows

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.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

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.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 … with a query, complete the following steps: Instantiate OracleCachedRowSet. Set

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

Row Set

Row Set Setup and ConfigurationThe 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

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

Row Set

CachedRowSet ConstraintsAll 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

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

Row Set

Runtime Properties for Row SetTypically, 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

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

Row Set

Traversing Through the Rowsway to implement a scrolling and updatable result set if they are not provided by the result set

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

Row Set

JDBC Row SetA 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Choosing a Character Set

2 Choosing a Character SetThis 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Choosing a 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Choosing a Character Set

Changing the Character Set After Database CreationYou 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Choosing a Character Set

Multilingual Database ScenariosMultilingual support can be restricted or unrestricted. This section contains the following topics: Restricted Multilingual Support Unrestricted Multilingual Support

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Choosing a Character Set

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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

PROCESS Character Set Scanner ParameterDefault value: 1 Minimum value: 1 Maximum value: 32 Purpose: Specifies the number of concurrent scan processes to utilize for the database scan

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

SUPPRESS Character Set Scanner ParameterSet 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"

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

Examples: Character Set Scanner SessionsThe following examples show you how to use the command-line and parameter-file methods to use Full Database, User, and Table scan modes.

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

Individual Exception Reportdatabase 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

Performance Considerationsnumber 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Migration

Data Truncationallows 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Migration

Migrating to the Oracle9 i NCHAR DatatypesUnicode 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

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

Result Set Enhancements

13 Result Set EnhancementsStandard 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,

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

Result Set Enhancements

OverviewThis section provides an overview of JDBC 2.0 result set functionality and categories, and some

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

Result Set Enhancements

Processing a Scrollable Result SetIn 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

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

Result Set Enhancements

Updating Result SetsA 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

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

Result Set Enhancements

Summary of Visibility of Internal and External ChangesTable 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",

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Choosing a Character Set

Character Set Encodingsets. 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

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Choosing a Character Set

Current and Future Language Requirementsrequirements 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.

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

Access PrivilegesTo use the Character Set Scanner, you must have DBA privileges on the Oracle database.

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

Scan Modes in the Character Set ScannerThe Character Set Scanner provides three modes of database scan: Full Database Scan User Scan Table Scan

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

Full Database ScanThe 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.

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Character Set Scanner

Getting Online Help for the Character Set ScannerThe 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