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 60 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)

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)

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

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*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

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*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)

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

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

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

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

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

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

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)...

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

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

Error Messages

WM_ERROR_155 the where-clause can involve only primary key columnsCause: An attempt was made to invoke a Workspace Manager operation with an invalid where_clause parameter as input. Action: Ensure that the input where_clause contains only valid column names and has proper syntax. The where_clause for this Workspace Manager operation can contain only columns that are part of the primary key.

Streams, 9i Release 2 (9.2.0.2)

Managing a Capture Process

Resetting the Log Sequence Number Where Changes Are CapturedTypically, database administrators reset the log sequence number of a database during point-in-time recovery. The ALTER DATABASE OPEN RESETLOGS statement is an example of a statement that resets the log sequence number. When you reset the log sequence number of a database, any existing local capture processes become unusable. If a capture process is capturing changes generated by a database for which

Streams, 9i Release 2 (9.2.0.2)

Managing a Capture Process

Changing the DBID of a Database Where Changes Are CapturedTypically, database administrators change the DBID of a database when it is a clone of another database. You can view the DBID for a database by querying the DBID column in the V$DATABASE dynamic performance view. If a capture process is capturing changes generated by a database for which you have changed the DBID, then complete the following steps: Shut down the database. Restart the database with

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

SQLJ Error Messages

Illegal Java type in cursor for WHERE CURRENT OFCause: No valid Java type could be derived for the iterator in the WHERE CURRENT OF clause.

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

Managing Tablespaces

Scenario 3: Fixing Bitmap Where Overlap is ReportedThe TABLESPACE_VERIFY procedure reports some overlapping. Some of the real data must be sacrificed based on previous internal errors. After choosing the object to be sacrificed, in this case say, table t1, perform the following tasks: Make a list of all objects that t1 overlaps. Drop table t1. If necessary, follow up by calling the SEGMENT_DROP_CORRUPT procedure. Call the SEGMENT_VERIFY procedure

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

Error Messages

WM_ERROR_81 invalid column name specified in the where-clauseCause: An attempt was made to invoke a Workspace Manager operation with an invalid where-clause … parameter as input. Action: Ensure that the input where-clause contains only valid column names and has proper syntax.

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

Introduction to BC4J

Where Can I Find More Information About BC4J?Answer: For additional information on BC4J and JDeveloper, please visit: http://otn.oracle.com/products/jdev/content.html For a good technical overview white paper of how BC4J can help J2EE and EJB developers be more productive, please see: http://otn.oracle.com/products/jdev/htdocs/j2ee_with_bc4j/j2ee_with_bc4j.html Copyright © 2001, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents

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

Migrating From LONGs to LOBs

Using utldtree.sql to Determine Where Your Application Needs ChangeUse the utility, rdbms/admin/utldtree.sql, to determine which parts of your application potentially need rewriting when you ALTER your LONG tables to LOBs. utldtree.sql allows you to see all objects that are (recursively) dependent on a given object. In addition, you will only see objects for which you have permission. Instructions on how to use utldtree.sql is documented in the file itself. Hence

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

SQLJ Error Messages

Java type type of iterator for WHERE CURRENT OF is not supported. It must implement sqlj.runtime.ForUpdate.Cause: The iterator in the WHERE CURRENT OF clause must be declared as implementing the interface sqlj.runtime.ForUpdate.

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

XSQL Pages Publishing Framework

Can I Use a Value Retrieved in One Query in Another Query's Where Clause?where col3 = {@col1} => the value of col1 in the previous query How can I use, in the second query … to the following example: select one from table1 where... select col3,col4 from table2 where col3 = ?

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

Introduction

Where Can I Find The On-line Versions of the Example Programs?Each Oracle installation should have a demo directory. If the directory is not there, or it does not contain the example programs, see your system or database administrator.

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

SQLJ Error Messages

Unable to check WHERE clause. Error returned by database is: errorCause: When determining the shape of a query from an exemplar schema, the database issued an error message. Action: Verify the syntax of your SQL query.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0692 Usage: CONNECT login AS SYSDBA|SYSOPER Where < login > ::= < username >/< password >@< connect_string…SP2-0692 Usage: CONN[ECT] [ login ] [AS [SYSDBA|SYSOPER]] Where::= [/][@] | / Cause: An invalid

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Frequently Asked Questions About Using Oracle Objects

Where are the user-defined types, user-defined functions, and abstract data types?The Oracle equivalent of a user-defined type or an abstract data type is an object type. The Oracle equivalent of a user-defined function is an object type method. We use these terms because their semantics are different from the common industry usage. For example, an Oracle object can be , while an object of an abstract data type cannot.

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Using Embedded SQL

Using the WHERE ClauseEXEC SQL DELETE FROM EMP WHERE DEPTNO =:dept_number; You can use the optional WHERE clause to … specify the condition under which rows are deleted. Using the WHERE Clause

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Using Host Arrays

Using the WHERE Clauseshows: EXEC SQL DECLARE emp_cursor CURSOR FOR SELECT ENAME, SAL FROM EMP WHERE EMPNO =:emp_number … UPDATE EMP SET SAL =:new_salary WHERE CURRENT OF emp_cursor; However, you cannot use the FOR clause with … =:new_salary WHERE CURRENT OF emp_cursor;... EXEC SQL FOR:limit DELETE FROM EMP WHERE CURRENT OF emp_cursor; Using

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

Coordinate Systems (Spatial Reference Systems)

INVERSE_FLATTENING NUMBER Inverse flattening of the ellipsoid. That is, 1/f, where f = a-b/a, and a…ellipsoid). INVERSE_FLATTENING NUMBER Inverse flattening of the ellipsoid. That is, 1/f, where f

Data Mining Concepts, 9i Release 2 (9.2.0.2)

Preface

Where to Find More Informationthe directory $ORACLE_HOME/dm/doc on any system where ODM is installed. Related Manuals For more

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Creating and Accessing Data Through URLs

Where Can DBUri Be Used?: Storing URLs to Related Documents In the case of a travel story Web site where you store travel

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Using Host Arrays

INTO Clause WHERE Clause Valid?Table 9 - 1 shows which uses of host arrays are valid in a SELECT INTO statement: INTO Clause WHERE

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-00967 missing WHERE keywordCause: The keyword WHERE in a SELECT statement was missing, misspelled, or misplaced. Action: Correct the syntax.

Programmer's Guide to the Oracle Precompilers 1.8 Go to Contents for this book, 9i Release 2 (9.2.0.2)

Using Host Arrays

SET Clause WHERE Clause Valid?statement: SET Clause WHERE Clause Valid? array array yes scalar scalar yes array scalar no scalar array no Table 9 - 2. Host Arrays Valid in UPDATE

Pro*Fortran Supplement to the Oracle Precompilers Go To Documentation Library, 9i Release 2 (9.2.0.2)

Implementing Dynamic SQL Method 4

Where Is the Information Stored?statement falls into this category: * Dynamic SQL statement STMT = 'DELETE FROM EMP WHERE DEPTNO = 30 … SET COMM =:C WHERE EMPNO =:E' rrTo execute a dynamic SQL statement that contains select-list items … variable. Where Is the Information Stored? All the information Oracle needs about select-list items

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02124 object type in WHERE clausetype in the WHERE clause. Action: Re-phrase the query to avoid the reference to the object type.

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Oracle XML DB Foldering

Where Exactly Is Repository Data Stored?Oracle XML DB stores Repository data in a set of tables and indexes in the Oracle XML DB database schema. These tables are accessible. If you register an XML schema and request the tables be generated by Oracle XML DB, the tables are created in your database schema. This means that you are able to see or modify them. However, other users will not be able to see your tables unless you explicitly grant

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-24348 Update or Delete without WhereCause: An UPDATE or DELETE was executed without a WHERE clause. Action: An OCI_SUCCESS_WITH_INFO is returned.

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

INFO BLOB Other information in a node. Includes an array of pairs maximum of…

INFO BLOB Other information in a node. Includes an array of pairs maximum of…each R-tree node, such pairs), where child_rowid is the rowid of a child node, or the rowid of a data

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0395 Usage: SQLPLUS < option > < logon > < start > Where < option > ::= -H | -V | -L -M -R SP2-0395 Usage: SQLPLUS [[] [] []] Where::= -H | -V | [[-L] [-M ] [-R ] [-S]] -H displays the SQL

Error Messages, 9i Release 2 (9.2.0.2)

interMedia Audio Messages (AUD)

AUD-00803 internal error while processing WHERE clauseCause: The WHERE clause could not be properly processed. Action: Contact Oracle Support Services.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-25957 join index where clause cannot contain cyclesCause: An attempt to create a join index was made, which failed because the where clause contains a … cycle. Action: Ensure that the where clause is in the form of a star or snowflake schema.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-04071 where command is one of following:Cause: Help message displayed by CMCTL. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Net Messages (TNS)

TNS-00071 where command is one of following:Cause: Help message displayed by INTCTL. Action: No action required.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-25950 missing where clause in join index specificationCause: An attempt to create a join index was made, which failed because no valid where clause was … found. Action: Ensure that a where clause with valid join conditions is specified in the create index statement.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01402 view WITH CHECK OPTION where-clause violationwould have resulted in the creation of a row that would not satisfy the view's WHERE clause. Action … : Examine the view's WHERE clause in the dictionary table VIEWS. If the current view does not have the … OPTION. The second view's WHERE clause must also be satisfied by any INSERT or UPDATE statements. To

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00116 Duplicate where-clause in table expressionCause: Two or more WHERE clauses were found in a DELETE, SELECT, or UPDATE statement. The WHERE … several logical expressions connected by AND or OR, but a statement can contain only one WHERE clause … . Action: Remove one of the WHERE clauses and, if necessary, connect logical expressions by AND or OR.

Error Messages, 9i Release 2 (9.2.0.2)

SQL Runtime Messages (SQL)

SQL-02118 Invalid row for a WHERE CURRENT OF operationCause: An attempt was made to reference a nonexistent row using the CURRENT OF clause in an UPDATE or DELETE statement. This happens when no FETCH has been executed or when FETCH returns a "no data found" error that the program fails to trap. Action: Check that the last cursor operation succeeded and that the current row of the cursor is valid. The outcome of a cursor operation can be checked in two

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-25951 join index where clause cannot contain OR conditionthe where clause. Action: Reformulate the where clause without using ORs.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-00923 FROM keyword not found where expectedREVOKE statement. Action: Correct the syntax. Insert the keyword FROM where appropriate. The SELECT

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02026 non-AND conjunction in WHERE clauseother than AND (such as OR ) in the WHERE clause. Action: Re-phrase the query to avoid use of the non- AND conjunction.

Error Messages, 9i Release 2 (9.2.0.2)

Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM)

QSM-02018 subquery present in the WHERE clausethe WHERE clause. Action: Re-phrase the query to avoid the subquery in the WHERE clause.