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 SELECT


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


SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on Subquery Factoringrows are those with matching values for each expression in the select list.

SQL Reference, 10g Release 1 (10.1)

SELECT

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

SQL Reference, 10g Release 1 (10.1)

SELECT

SELECTPurpose 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

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on DISTINCT and UNIQUE QueriesWhen 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

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on the Select ListIf 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

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on the FOR UPDATE ClauseUse 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

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on Partitioned Outer Joinsyou 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

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on Flashback Queriesdata 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

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on the ORDER BY Clauseoperator 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

SQL Reference, 10g Release 1 (10.1)

SELECT

Restrictions on the reference_model clauseset 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

User's Guide and Reference, 10g Release 1 (10.1)

SELECT INTO Statement

SELECT INTO StatementThe 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.

DML Reference, 10g Release 1 (10.1)

SQL

SQL SELECTThe 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

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

Example: Select Approver (Oracle Workflow Developer's Guide)

Example: Select ApproverThe Select Approver function activity calls a PL/SQL stored procedure named

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Implementing Dynamic SQL Method 4

DESCRIBE the Select ListSelect 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.

DML Reference, 10g Release 1 (10.1)

SQL

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

Release 1.8, 10g Release 1 (10.1)

Embedded SQL Commands and Directives

SELECT (Executable Embedded SQL)Purpose To retrieve data from one or more tables, views, or snapshots, assigning the selected values to host variables.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

2 Precompiler Concepts

2.4.2 Example SELECT StatementIn 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

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

6 Embedded SQL

6.3.1 The SELECT StatementQuerying 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

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

4 Using SQL Statements in OCI

Describing Select-list Itemsitems 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

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

11 Oracle Dynamic SQL: Method 4

11.6.12 DESCRIBE the Select ListIf 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