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


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


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