Results for WHERE


21 to 40 of 6032 results. Prev  Next
Results per page:   20  | 40 | 60


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 … be carried forward. The following code example demonstrates where user code can be added in a.cpp

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

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.

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

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

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

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

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.

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.

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

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

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.

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.

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

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.

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.

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





Was this page helpful?

Integrated Cloud Applications & Platform Services