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 WHERE


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


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

WHEREWITH *

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL

Using the WHERE ClauseYou use the WHERE clause to select, update, or delete only those rows in a table or view that meet … your search condition. The WHERE-clause search condition is a Boolean expression, which can include … scalar host variables, host arrays (not in SELECT statements), and subqueries. If you omit the WHERE … clause, all rows in the

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Host Tables

The WHERE ClauseWHERE JOB =:JOB-TITLE END-EXEC. were treated like the following statement PERFORM VARYING I FROM 1 BY … 1 UNTIL I = 50 SELECT MGR INTO:MGR-NUMBER(I) FROM EMP WHERE JOB =:JOB_TITLE(I) END-EXEC END … -PERFORM. because multiple rows might meet the WHERE-clause search condition, but only one output variable … be ambiguous if the statement

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

Host Arrays

Using the WHERE ClauseEXEC SQL SELECT mgr INTO:mgr_number FROM emp WHERE job =:job_title; were treated like the imaginary … statement for (i = 0; i because multiple rows might meet the WHERE-clause search condition, but only … other hand, it would not be ambiguous if the statement EXEC SQL UPDATE emp SET mgr =:mgr_number WHERE … empno IN (SELECT empno

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

Embedded SQL

The WHERE ClauseUse the WHERE clause to SELECT, UPDATE, or DELETE only those rows in a table or view that meet your … search condition. The WHERE-clause search condition is a Boolean expression, which can include … functions. If you omit the WHERE clause, all rows in the table or view are processed. If you omit the … WHERE clause

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

SQLJ Error Messages

Expected: WHERE CURRENT OF :hostvar. Found: WHERE CURRENT OF token ...Action: Use proper syntax in the WHERE CURRENT OF clause.

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

SQLJ Error Messages

Expected: WHERE CURRENT OF :hostvar. Found: WHERE CURRENT token ...Action: Use proper syntax in the WHERE CURRENT OF clause.

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

The Object Type Translator

Where OTT Parameters Can AppearSupply OTT parameters on the command line, in a CONFIG file named on the command line, or both. Some parameters are also allowed in the INTYPE file. OTT is invoked as follows: OTT username/password parameters If one of the parameters on the command line is CONFIG= filename additional parameters are read from the configuration file named filename. In addition, parameters are also read from a default

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

How to Use the Object Type Translator Utility

Where OTT Parameters Can AppearSupply OTT parameters on the command line, in a CONFIG file named on the command line, or both. Some parameters are also allowed in the INTYPE file. The OTT utility is invoked as follows: OTT parameters You can name a configuration file on the command line with the CONFIG parameter as follows: CONFIG=filename If you name this parameter on the command line, then additional parameters are read from

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

The Object Type Translator (OTT)

Where OTT Parameters Can AppearOTT parameters can appear on the command line, in a CONFIG file named on the command line, or both. Some parameters are also allowed in the intype file. OTT is invoked as follows: OTT username/password parameters If one of the parameters on the command line is config=filename additional parameters are read from the configuration file filename. In addition, parameters are also read from a default configuration

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

Implementing Dynamic SQL Method 4

Where Is the Information Stored?variables in a select or bind SQLDA so that Oracle knows where to write output values and read input

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL: Method 4

Where the Information is Storedwhere to write output values and read input values. How do values get stored in these data variables

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

Oracle Dynamic SQL: Method 4

Where Is the Information Stored?that Oracle knows where to write output values and read input values. How do values get stored in

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

Managing Hash Clusters

Situations Where Hashing Is Usefulcluster key:SELECT... WHERE cluster_key =...; In such cases, the cluster key in the equality

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Working with Labeled Data

Using Numeric Label Tags in WHERE ClausesThis section describes techniques of using numeric label tags in WHERE clauses of SELECT statements … * FROM emp WHERE hr_label BETWEEN 2000 AND 2999; To list all SENSITIVE and UNCLASSIFIED records … , you can enter: SELECT * FROM emp WHERE hr_label To list all HIGHLY_SENSITIVE records, you can enter … : SELECT * FROM emp WHERE

XML Developer's Kits Guide - XDK, 9i Release 2 (9.2.0.2)

XSQL Pages Publishing Framework

Where Can I Obtain Oracle XSQL Pages?://otn.oracle.com/tech/xml. Where indicated, the examples and demos described in this chapter are also available from OTN.

Data Mining Administrator's Guide, 9i Release 2 (9.2.0.2)

Oracle9i Data Mining Administrator's Guide

1.3 Where to Find Further Informationabout the ODM API, see the ODM Javadoc in the directory $ORACLE_HOME/dm/doc on any system where ODM is

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

How to Use the Object Type Translator Utility

Where the Markers Can Be UsedOTT generated declarations in either access specifiers. The following code example demonstrates where … carried forward. The following code example demonstrates where user code can be added in a.cpp

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

Managing Hash Clusters

Situations Where Hashing Is Not Advantageousequivalent of a full table scan must be done to fetch the rows for the query.SELECT... WHERE cluster_key … With an index, key values are ordered in the index, so cluster key values that satisfy the WHERE

Application Developer's Guide - Large Objects, 9i Release 2 (9.2.0.2)

Modeling and Design

SQL Features Where LOBs Cannot be UsedTable 7-8 lists other SQL features where LOBs cannot be used. Refer to the "LOB Restrictions … " section in Chapter 4, "Managing LOBs", for further details. Table 7-8 SQL Features Where LOBs Cannot be … clobCol2 from tab2; JOIN SELECT... FROM... WHERE tab1.clobCol = tab2.clobCol INDEX CREATE INDEX clobIndx ON tab(clobCol)...