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 1411 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60

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

Introduction to OCCI

Queriesrows of data. All queries begin with the SQL keyword SELECT, as in the following example: SELECT … dname FROM dept WHERE deptno = 42 Queries can require the program to supply data to the database server

Application Developer's Guide, 9i Release 2 (

Performance Tuning

Parallel Queriesis the default query behavior for local indexes created in parallel. In general, parallel queries … query can result in degrading your overall query throughput. In addition, typical top N text queries

Database, 9i Release 2 (

Queries Page

Queries PageQueries Page none    Related Topics none About the Query API About the Administration Tool none none … of the following categories: Daily summary of query statistics Top 50 queries Top 50 ineffective … queries Top 50 failed queries Daily Summary of Query Statistics This summarizes all query activity on … queries

SQL Reference, 9i Release 2 (

SQL Queries and Subqueries, 11 of 11

Distributed QueriesDistributed Queries Distributed queries are currently subject to the restriction that all tables … distributed queries that select user-defined types or object REF s on remote tables.

Data Cartridge Developer's Guide, 9i Release 2 (

Power Demand Cartridge Example

Sample QueriesModelling the application in this way, makes possible the following specific queries: Find the cell … percent or more over the preceding time's total demand. These queries are, of course, only a short … that the developer of such an application would want to build queries that are based on the information … derived from prior

Application Developer's Guide, 9i Release 2 (

Introduction to Oracle Text

Thesaural Queriesthesaurus enables you to process queries more intelligently. Since users of your application might not know

Objects for OLE, 9i Release 2 (

Executing Queries

Executing QueriesFeedback Executing Queries Queries are statements that retrieve data from a database. A query can return … zero, one, or many rows of data. All queries begin with the SQL keyword SELECT, as in the following … CreateDynaset method of the OraDatabase interface to execute queries. This method returns an OraDynaset

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (

DBMS_SQL, 1 of 2

Processing QueriesIf you are using dynamic SQL to process a query, then you must perform the following steps: Specify the variables that are to receive the values returned by the  SELECT statement by calling DEFINE_COLUMN, DEFINE_COLUMN_LONG, or DEFINE_ARRAY. Run your SELECT statement by calling EXECUTE. Call FETCH_ROWS (or EXECUTE_AND_FETCH ) to retrieve the rows that satisfied your query. Call COLUMN_VALUE or COLUMN_VALUE_LONG

SQL Reference, 9i Release 2 (

SQL Queries and Subqueries, 4 of 11

Hierarchical QueriesHierarchical Queries Text description of the illustration queries4.gif To find the children of a parent row

Data Warehousing Guide, 9i Release 2 (

Schema Modeling Techniques

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

SQL Reference, 9i Release 2 (

SQL Queries and Subqueries, 3 of 11

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 to return from one or more tables, views, or materialized views. The number of columns, as well as their datatype and length, are determined by the elements of the select list. If two or more tables

Data Warehousing Guide, 9i Release 2 (

Query Rewrite

How Oracle Rewrites Queriesdefinition. This method is most straightforward but the number of queries eligible for this type of query

Reference Guide, 9i Release 2 (

Application Performance Tuning

Qualified and Restricted QueriesYou can reduce network traffic by requesting only the columns you need from a table. You should also use the most restrictive qualifications possible to reduce the size of the query result set.

Application Developer's Guide, 9i Release 2 (


ABOUT Queries and Themesconcepts and terms specific to your industry or query application. When you do so, ABOUT queries are more … precise for the added concepts. ABOUT queries perform best when you create a theme component in your

SQL Reference, 9i Release 2 (

SQL Queries and Subqueries, 2 of 11

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

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

Relational Programming

Executing SQL QueriesSQL query statements allow your applications to request information from a database based on any constraints specified. A result set is returned as a result of a query.

Application Developer's Guide, 9i Release 2 (

Performance Tuning

Optimizing Queries for ThroughputOptimizing a query for throughput returns all hits in the shortest time possible. This is the default behavior. The following sections describe how you can explicitly optimize for throughput.

Administrator's Guide, 9i Release 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

Application Developer's Guide, 9i Release 2 (

Performance Tuning

Optimizing Queries with StatisticsQuery optimization with statistics uses the collected statistics on the tables and indexes in a query to select an execution plan that can process the query in the most efficient manner. As a general rule, Oracle recommends that you collect statistics on your base table if you are interested in improving your query performance. The optimizer attempts to choose the best execution plan based on the

Application Developer's Guide - Fundamentals, 9i Release 2 (

Managing Schema Objects

Using Views in QueriesViews 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 EMPNO JOB DNAME ------------------------------------------------------ CLARK 7782 MANAGER ACCOUNTING KING 7839 PRESIDENT ACCOUNTING MILLER 7934 CLERK ACCOUNTING ALLEN 7499 SALESMAN SALES WARD 7521 SALESMAN SALES