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
Distributed Queries → databases 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.
Hierarchical Queries → functionality 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
About Queries and Subqueries → called a subquery. This section describes some types of queries and subqueries and how to use them. The
Tuning Distributed Queries → queries, 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
Using Views in Queries → To 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
Creating Simple Queries → The 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
Hierarchical Query Examples → Figure 9-1 Hierarchical Queries Description of ''Figure 9-1 Hierarchical Queries'' To find the
Tune Function Invocations in Queries → Functions 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
Variables in Cursor Variable Queries → The 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,
9 SQL Queries and Subqueries → This 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
Queries → Queri 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
Queries → data. 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
7.6.3 Specifying Queries for Result Caching → queries are eligible to be cached. 18.104.22.168 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
12.6.1 Viewing Parallel Queries with EXPLAIN PLAN → physical 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
Optimizing Star Queries → You should consider the following when using star queries: Tuning Star Queries Using Star Transformation
How Oracle Rewrites Queries → number of queries eligible for this type of query rewrite is minimal. When the text comparison test
Tuning Star Queries → To 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
24 Advanced Business Intelligence Queries → This 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
Examples of Business Intelligence Queries → The 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