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 queries


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


Database SQL Language Reference, 11g Release 2 (11.2)

Distributed Queries

Distributed Queriesdatabases Restrictions on Distributed Queries   Distributed queries are currently subject to the … distributed queries that select user-defined types or object REF data types on remote tables.

Database SQL Language Reference, 11g Release 2 (11.2)

Hierarchical Queries

Hierarchical Queriesfunctionality of the CONNECT BY [ PRIOR ] condition of hierarchical queries by returning not only the … information about this operator and \"Hierarchical Query Examples\" Oracle processes hierarchical queries

Database SQL Language Reference, 11g Release 2 (11.2)

About Queries and Subqueries

About Queries and Subqueriescalled a subquery. This section describes some types of queries and subqueries and how to use them. The

Database Administrator's Guide, 11g Release 2 (11.2)

Developing Applications for a Distributed Database System

Tuning Distributed Queriesqueries, which it then sends to the remote nodes for execution. The remote nodes execute the … queries and send the results back to the local node. The local node then performs any necessary post

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Views, Sequences, and Synonyms

Using Views in QueriesTo issue a query or an INSERT, UPDATE, or DELETE statement against a view, you must have the SELECT, INSERT, UPDATE, or DELETE object privilege for the view, respectively, either explicitly or through a role. Views can be queried in the same manner as tables. For example, to query the Division1_staff view, enter a valid SELECT statement that references the view: SELECT * FROM Division1_staff; ENAME

Database SQL Language Reference, 11g Release 2 (11.2)

Creating Simple Queries

Creating Simple QueriesThe list of expressions that appears after the SELECT keyword and before the FROM clause is called the select list. Within the select list, you specify one or more columns in the set of rows you want Oracle Database to return from one or more tables, views, or materialized views. The number of columns, as well as their data type and length, are determined by the elements of the select list. If two

Database SQL Language Reference, 11g Release 2 (11.2)

Hierarchical Queries

Hierarchical Query ExamplesFigure 9-1 Hierarchical Queries Description of ''Figure 9-1 Hierarchical Queries'' To find the

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

Tune Function Invocations in QueriesFunctions invoked in queries might run millions of times. Do not invoke a function in a query … only those rows. In Example 12-5, the two queries produce the same result set, but the second query is

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Static SQL

Variables in Cursor Variable QueriesThe query associated with a cursor variable can reference any variable in its scope. When you open a cursor variable with the OPEN FOR statement, PL/SQL evaluates any variables in the query and uses those values when identifying the result set. Changing the values of the variables later does not change the result set. Example 6-28 opens a cursor variable for a query that references the variable factor,

Database SQL Language Reference, 11g Release 2 (11.2)

SQL Queries and Subqueries

9 SQL Queries and SubqueriesThis chapter describes SQL queries and subqueries. This chapter contains these sections: About … Queries and Subqueries Creating Simple Queries Hierarchical Queries The UNION [ALL], INTERSECT, MINUS … Operators Sorting Query Results Joins Using Subqueries Unnesting of Nested Subqueries Selecting from the DUAL Table Distributed

Oracle C++ Call Interface Programmer's Guide, 11g Release 2 (11.2)

Introduction to OCCI

QueriesQueri es Queries are statements that retrieve data from tables in a database. A query can return … zero, one, or many rows of data. All queries begin with the SQL keyword SELECT, as in Example 1-6 … department_id = 30 Queries can require the program to supply data to the database server by using input bind

Objects for OLE Developer's Guide for Microsoft Windows, 11g Release 2 (11.2)

Basic Features

Queriesdata. All queries begin with the SQL keyword SELECT, as in the following example: SELECT ename, empno … OraDatabase interface to execute queries. This method returns an OraDynaset object that is then used to … provides a way to insert new rows. See \"OraDynaset Object\". Queries can also require the program to

Database Performance Tuning Guide, 11g Release 2 (11.2)

Configuring and Using Memory

7.6.3 Specifying Queries for Result Cachingqueries are eligible to be cached. 7.6.3.1 About the Result Cache Mode The result cache mode is a … database setting that determines which queries are eligible to store result sets in the client and … server result caches. Oracle Database recommends that applications cache results for queries of read

Database Performance Tuning Guide, 11g Release 2 (11.2)

Using EXPLAIN PLAN

12.6.1 Viewing Parallel Queries with EXPLAIN PLANphysical I/O and CPU time. For parallel queries, the choice of the driving table is usually the … Columns\" 12.6.1 Viewing Parallel Queries with EXPLAIN PLAN When using EXPLAIN PLAN with parallel … queries, the database compiles and executes one parallel plan. This plan is derived from the serial

Database Data Warehousing Guide, 11g Release 2 (11.2)

Schema Modeling Techniques

Optimizing Star QueriesYou should consider the following when using star queries: Tuning Star Queries Using Star Transformation

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

How Oracle Rewrites Queriesnumber of queries eligible for this type of query rewrite is minimal. When the text comparison test

Database Data Warehousing Guide, 11g Release 2 (11.2)

Schema Modeling Techniques

Tuning Star QueriesTo get the best possible performance for star queries, it is important to follow some basic … important optimizer feature for star-queries. It is set to FALSE by default for backward-compatibility … . When a data warehouse satisfies these conditions, the majority of the star queries running in the … transformation provides very

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Business Intelligence Queries

24 Advanced Business Intelligence QueriesThis chapter illustrates techniques for handling advanced business intelligence queries. We hope to … makes a business intelligence query \"advanced\"? The label is best applied to multistep queries … , often involving dimension hierarchies. In such queries, the final result depends on several sets of … dimension hierarchy. Prime

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Business Intelligence Queries

Examples of Business Intelligence QueriesThe queries in this chapter illustrate various business intelligence tasks. The topics of the … queries and the features used in each query are: Percent change in market share based on complex

Database Data Warehousing Guide, 11g Release 2 (11.2)

Schema Modeling Techniques

Optimizing Third Normal Form QueriesQueries on 3NF schemas are often very complex and involve a large number of tables. The performance