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
Restrictions on Subquery Factoring → rows are those with matching values for each expression in the select list.
Restrictions on the GROUP BY Clause: The expressions can be of any form except scalar subquery expressions.… → main_model The main_model clause defines how the selected rows will be viewed in a multidimensional array and what rules will operate on which cells in that array. model_column_clauses The model_column_clauses define and classify the columns of a query into three groups: partition columns, dimension columns, and measure columns. PARTITION BY The PARTITION BY clause specifies the columns that will
SELECT → Purpose Use a SELECT statement or subquery to retrieve data from one or more tables, object tables … , views, object views, or materialized views. If part or all of the result of a SELECT statement is … place of one or more tables specified in the SELECT statement. This substitution is called query … Additional Topics Prerequisites
Restrictions on DISTINCT and UNIQUE Queries → When you specify DISTINCT or UNIQUE, the total number of bytes in all select list expressions is … . The default is ALL. * (asterisk) Specify the asterisk to select all columns from all tables, views … the object name followed by a period and the asterisk to select all columns from the specified … , views, or materialized views
Restrictions on the Select List → If you also specify a group_by_clause in this statement, then this select list can contain only the … expressions that evaluate to the same value for all rows in a group You can select a rowid from a join … number or timestamp for each object in the select list. You can also implement session-level Flashback
Restrictions on the FOR UPDATE Clause → Use the OF... column clause to lock the select rows only for a particular table or view in a join … SELECT statement attempts to lock a row that is locked by another user. NOWAIT Specify NOWAIT to return … the SELECT statement. Examples Subquery Factoring: Example The following statement creates the query … query names in the
Restrictions on Partitioned Outer Joins → you select rows in a hierarchical order. SELECT statements that contain hierarchical queries can … contain the LEVEL pseudocolumn in the select list. LEVEL returns the value 1 for a root node, 2 for a … clause, regardless of whether the columns appear in the select list. The GROUP BY clause groups rows but
Restrictions on Flashback Queries → data is selected. sample_clause The sample_clause lets you instruct the database to select from a … for evaluating the query. This alias is required if the select list references any object type … identify tables that are part of a join from which to select data. The inner_cross_join_clause lets
Restrictions on the ORDER BY Clause → operator in this statement, then this clause cannot refer to columns unless they appear in the select list … can specify this clause only in a top-level SELECT statement, not in subqueries. Note: Prior to … embedded SELECT... FOR UPDATE statement. You can do this using one of the programmatic languages or
Restrictions on the reference_model clause → set operators combine the rows returned by two SELECT statements into a single result. The number … the select list preceding the set operator. If you combine more than two queries with set operators … expression is based on columns in the select list or columns in the tables, views, or materialized … expression in this position
SELECT INTO Statement → The SELECT INTO statement retrieves data from one or more database tables, and assigns the selected … values to variables or collections. For a full description of the SELECT statement, see Oracle … Database SQL Reference. In its default usage ( SELECT... INTO ), this statement retrieves one or more … columns from a single row.
SQL SELECT → The SQL SELECT command uses an implicit cursor to copy data from relational tables into analytic … workspace objects. Syntax SQL SELECT expressions FROM tables - [WHERE predicates ] [GROUP BY
Example: Select Approver → The Select Approver function activity calls a PL/SQL stored procedure named
DESCRIBE the Select List → Select List If the dynamic SQL statement is a query, the DESCRIBE SELECT LIST statement must follow the OPEN statement and must precede the FETCH statement.
SELECT expressions FROM tables- → SELECT statement that identifies the data you want to associate with the cursor. For the syntax of an … SQL SELECT statement, refer to the Oracle Database SQL Reference. targets Identifies the analytic … table columns specified in the SELECT statement. A target can be a variable, a qualified data reference … following: assignment-statement
SELECT (Executable Embedded SQL) → Purpose To retrieve data from one or more tables, views, or snapshots, assigning the selected values to host variables.
2.4.2 Example SELECT Statement → In the following example, the SELECT statement is precompiled only when the symbol site2 is defined … : EXEC ORACLE IFDEF site2; EXEC SQL SELECT DNAME INTO:dept_name FROM DEPT WHERE DEPTNO
6.3.1 The SELECT Statement → Querying the database is a common SQL operation. To issue a query you use the SELECT statement. In … the following example, you query the EMP table: EXEC SQL SELECT ename, job, sal + 2000 INTO … following the keyword SELECT make up the select list. The select list in our example contains three items
Describing Select-list Items → items in the select-list. This is particularly true for dynamic queries whose contents are not known … column lengths of the select-list items. This information is necessary to define output variables that … about the columns in the employees table: SELECT * FROM employees There are two types of describes … the information. An
11.6.12 DESCRIBE the Select List → If the dynamic SQL statement is a query, the DESCRIBE SELECT LIST statement must follow the OPEN … statement but precede the FETCH statement. DESCRIBE SELECT LIST puts descriptions of select-list items … into a select descriptor. In our example, DESCRIBE readies SELDSC as follows: EXEC SQL DESCRIBE … SELECT