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 WHEN


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


Programmer's Guide, 10g Release 1 (10.1)

Miscellaneous Functions

when (IN)Defines when the callback is invoked. Valid modes are: OCI_CBTYPE_ENTRY - the callback is invoked

Programmer's Guide, 10g Release 1 (10.1)

Miscellaneous Functions

when (IN)The when value of the callback.

Programmer's Guide, 10g Release 1 (10.1)

Miscellaneous Functions

when (IN)Defines when the callback is invoked. Valid modes are: OCI_CBTYPE_ENTRY - the callback is invoked

Utilities, 10g Release 1 (10.1)

14 The ORACLE_LOADER Access Driver

LOAD WHENThe LOAD WHEN condition_spec clause is used to identify the records that should be passed to the … definition without errors. See condition_spec. The following are some examples of using LOAD WHEN: LOAD … WHEN (empid != BLANKS) LOAD WHEN ((dept_id = "SPORTING GOODS" OR dept_id = "SHOES") AND total_sales != 0)

Concepts, 10g Release 1 (10.1)

2 Data Blocks, Extents, and Segments

When Extents Are AllocatedWhen you create a table, Oracle allocates to the table's data segment an initial extent of a

Guide, 10g Release 1 (10.1)

20 SQL for Aggregation in Data Warehouses

Considerations when Using AggregationThis section discusses the following topics. Hierarchy Handling in ROLLUP and CUBE Column Capacity in ROLLUP and CUBE HAVING Clause Used with GROUP BY Extensions ORDER BY Clause Used with GROUP BY Extensions Using Other Aggregate Functions with ROLLUP and CUBE

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

When to Use XMLTypebuilt-in C XML parser and processor and hence provides better performance and scalability when used

Guide, 10g Release 1 (10.1)

20 SQL for Aggregation in Data Warehouses

When to Use CUBEConsider Using CUBE in any situation requiring cross-tabular reports. The data needed for cross-tabular reports can be generated with a single SELECT using CUBE. Like ROLLUP, CUBE can be helpful in generating summary tables. Note that population of summary tables is even faster if the CUBE query executes in parallel. CUBE is typically most suitable in queries that use columns from multiple dimensions

Guide, 10g Release 1 (10.1)

20 SQL for Aggregation in Data Warehouses

When to Use ROLLUPUse the ROLLUP extension in tasks involving subtotals. It is very helpful for subtotaling along a hierarchical dimension such as time or geography. For instance, a query could specify a ROLLUP(y, m, day) or ROLLUP(country, state, city). For data warehouse administrators using summary tables, ROLLUP can simplify and speed up the maintenance of summary tables.

Guide, 10g Release 1 (10.1)

20 SQL for Aggregation in Data Warehouses

When to Use GROUPINGThe GROUPING function is not only useful for identifying NULLs, it also enables sorting subtotal rows and filtering results. In Example 20-8, you retrieve a subset of the subtotals created by a CUBE and none of the base-level aggregations. The HAVING clause constrains columns that use GROUPING functions. Example 20-8 GROUPING Combined with HAVING SELECT channel_desc, calendar_month_desc, country_iso_code,

Concepts, 10g Release 1 (10.1)

2 Data Blocks, Extents, and Segments

When Extents Are Deallocatedextents of a rollback segment if it has the OPTIMAL size specified. When extents are freed, Oracle … you drop a nonclustered table, this space can be reclaimed when other extents require free space … dictionary managed tablespaces, when a segment requires an extent larger than the available extents, Oracle … to an index segment

Performance Tuning Guide, 10g Release 1 (10.1)

8 I/O Configuration and Design

When to Separate FilesRegardless of whether you use operating system striping or manual I/O distribution, if the I/O system or I/O layout is not able to support the I/O rate required, then you need to separate files with high I/O rates from the remaining files. You can identify such files either at the planning stage or after the system is live. The decision to segregate files should only be driven by I/O rates, recoverability

Backup and Recovery Advanced User's Guide, 10g Release 1 (10.1)

13 Managing the Recovery Catalog

When Should You Resynchronize?resynchronization (depending on whether the schema metadata has changed) automatically when the target … manual resynchronization is required. Resynchronizing When the Recovery Catalog is Unavailable If the … recovery catalog is unavailable when you issue RMAN commands that cause a partial resynchronization … . Resynchronizing

Performance Tuning Guide, 10g Release 1 (10.1)

15 Managing Optimizer Statistics

When to Gather StatisticsWhen gathering statistics manually, you not only need to determine how to gather statistics, but … also when and how often to gather new statistics. For an application in which tables are being

Performance Tuning Guide, 10g Release 1 (10.1)

15 Managing Optimizer Statistics

Considerations When Gathering StatisticsThis section discusses: When to Use Manual Statistics Restoring Previous Versions of Statistics … Locking Statistics When to Use Manual Statistics Automatic statistics gathering should be sufficient … are two approaches: The statistics on these tables can be set to NULL. When Oracle encounters a … that represent the typical state

Utilities, 10g Release 1 (10.1)

20 Original Export and Import

Considerations When Exporting Database ObjectsThe following sections describe points you should consider when you export particular database … ensure that the sequences are not accessed during the export. Sequence numbers can be skipped only when … cached sequence numbers are in use. When a cache of sequence numbers has been allocated, they are … cached values). Sequence

Reference, 10g Release 1 (10.1)

Changing Parameter Values in a Parameter File

When Parameters Are Set Incorrectlytypes of parameters in your parameter files: Parameters that you never alter except when instructed to … because their values are calculated automatically by the Oracle database server When Parameters Are Set … Oracle returns an error. Frequently, you can wait a short while and retry the operation when the

Guide, 10g Release 1 (10.1)

15 Maintaining the Data Warehouse

When Fast Refresh is PossibleNot all materialized views may be fast refreshable. Therefore, use the package DBMS_MVIEW.EXPLAIN_MVIEW to determine what refresh methods are available for a materialized view. See Chapter 8, " Basic Materialized Views" for further information about the DBMS_MVIEW package. If you are not sure how to make a materialized view fast refreshable, you can use the DBMS_ADVISOR.TUNE_MVIEW procedure, which

Database, 10g Release 1 (10.1)

Apache Tutorial: Introduction to Server Side Includes

When was this document modified?Earlier, we mentioned that you could use SSI to inform the user when the document was most recently

Administrator's Guide, 10g Release 1 (10.1)

18 Managing Hash Clusters

When to Use Hash ClustersThis section helps you decide when to use hash clusters by contrasting situations where hashing is