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


SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: SAVEPOINT to UPDATE, 3 of 8

SELECTPurpose Use a SELECT statement or subquery to retrieve data from one or more tables, object tables … , views, object views, or materialized views. Note: If the result (or part of the result) of a SELECT … in place of one or more tables specified in the SELECT statement. This substitution is called query

Objects for OLE, 9i Release 2 (9.2.0.2)

Select for Update

Select for UpdateMaster Index Feedback Select for Update Normally, when a dynaset is created, rows are not locked in … the database until StartEdit is invoked. If this is not desirable, the SQL SELECT statement could … is necessary because the Oracle database functions do not distinguish between SELECT and SELECT FOR

Objects for OLE, 9i Release 2 (9.2.0.2)

SELECT ... FOR UPDATE Example

''SELECT ... FOR UPDATE'' ExampleFeedback ''SELECT... FOR UPDATE'' Example This example demonstrates the use of SELECT... FOR UPDATE to … = OraDatabase.CreateDynaset("select * from emp FOR UPDATE", 0&) ' Create a field object for faster access

Objects for OLE, 9i Release 2 (9.2.0.2)

"SELECT ... FOR UPDATE"

"SELECT ... FOR UPDATE"Feedback "SELECT... FOR UPDATE" Normally, when a dynaset is created, rows are not locked in the database … SQL SELECT statement. Unfortunately, the FOR UPDATE construct undermines normal dynaset operations … Oracle database functions do not distinguish between SELECT and SELECT FOR UPDATE SQL statements.) It

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

Select Descriptorselect-list value. The format of the length differs among Oracle datatypes. For character datatypes … (VARCHAR2 and CHAR), SQLDVLN is set to the number of bytes in the select-list item. For NUMBER … table was established with no explicit precision and scale, or the precision and scale for the select … to a format conversion string.

Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (9.2.0.2)

Microsoft SQL Server, Sybase Adaptive Server, and Oracle Compared

SELECT StatementSELECT Statements in Oracle and Microsoft SQL Server and Sybase Adaptive Server   Microsoft SQL Server … and Sybase Adaptive Server Oracle Syntax: SELECT [ALL | DISTINCT] {select_list} [INTO [owner.]table … search_condition] [UNION [ALL] SELECT...] [ORDER BY {[[owner.]{table | view }.]column … [, column...]]] [FOR BROWSE] The

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

Select Descriptorfetching select-list items. For select descriptors, when Oracle executes the statement EXEC SQL FETCH … ... USING DESCRIPTOR SELDSC; if the Jth returned select-list item is NULL, the indicator-variable value

Pro*PL/I Supplement to the Oracle Precompilers Guide, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

Select Descriptorthe select-list value. This datatype code determines how the Oracle data will be converted into the … "Datatypes in the SQLDA" section later in this chapter. Note: In a select descriptor, the high-order bit of

Workflow Guide (Oracle Workflow Help), 9i Release 2 (9.2.0.2)

Example: Select Approver (Oracle Workflow Help)

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

Workflow Guide (Oracle Workflow Help), 9i Release 2 (9.2.0.2)

Example: Select Approver (Oracle Workflow Help)

Oracle Workflow Guide Release 2.6.2                              Contents   Index   Glossary Master Index Feedback

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 1 of 52

SELECT INTO StatementSERIALLY_REUSABLE Pragma

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Basic Language Features

SELECT INTO Error ConditionsRemember that SELECT INTO statements are intended for queries that return exactly one row of data … only. A SELECT INTO query that finds zero rows or multiple rows will result in an exception, as … follows: A SELECT INTO finding now rows will return an exception with a SQL state of 2000, representing a … "no data" condition. A

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Basic Concepts, 5 of 6

Using SQL SELECT StatementsSQL programmers can query analytic workspace data using SQL SELECT statements. If the analytic … SQL SELECT statements against these SQL views. This method requires minimum knowledge of the … function in SQL SELECT statements. This method requires intimate knowledge of the analytic workspace data

Configuration Guide, 9i Release 2 (9.2.0.2)

Configuring and Controlling the Management Server

Select Repository User TablespacesThe Select Repository User Tablespaces page does not appear: If the repository user already exists … owned by user '' on service ''?" If you click Yes or No, the following page appears. Figure 3-11 SelectSelect the default and temporary tablespaces for the Enterprise Manager repository to use. If the … OEM_REPOSITORY tablespace

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Precompiler Concepts

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, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Directives

SELECT (Executable Embedded SQL)values to host variables. Prerequisites For you to select data from a table or snapshot, the table or … snapshot must be in your own schema or you must have SELECT privilege on the table or snapshot. For you … to select rows from the base tables of a view, the owner of the schema containing the view must … have SELECT

Configuration Guide, 9i Release 2 (9.2.0.2)

Configuring and Controlling the Management Server

Select Database LocationHome that contains a 9 i database server installation. Figure 3-7 Select Database Location Text … change your SID, click Change SID. In another existing database. You will be prompted to select an … running. If you select the In a new local database instance option without clicking Change Database … details. If you select

Configuration Guide, 9i Release 2 (9.2.0.2)

Configuring and Controlling the Management Server

Select Database for RepositoryLog in to the database where you want to create the repository. Figure 3-9 Select Database for

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Basic Language Features

SELECT INTO SyntaxThe syntax for a SELECT INTO statement is as follows: #sql { SELECT expression1,..., expressionN … for any SELECT statement. This list of expressions is referred to as the SELECT-list. In a simple case … expression in the SELECT-list. See "Examples of SELECT INTO Statements" below. The

Programmer's Guide, 9i Release 2 (9.2.0.2)

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 … will receive query results. For example, a user might enter a query such as SELECT * FROM employees … a select-list