Results for ORDER


41 to 100 of 2659 results. Prev  Next
Results per page:  20 | 40 |  60 


Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

order Specify TRUE for Oracle to search for terms in the order you specify. The default is FALSE. For…that have the order flag set differently. For example, Oracle might return different scores for the

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

A Sample Application Using Object-Relational Features

Line 6 of the INSERT statement specifies values for the three purchase order attributes PONo, OrderDate, and ShipDate. Only attribute values are given; no purchase order constructor is specified. You do … not need to explicitly specify a purchase order constructor to instantiate a purchase order … . If you omit a purchase order constructor, the system instantiates a purchase order automatically

Sample Schemas, 9i Release 2 (9.2.0.2)

Installation

Installing the Order Entry (OE) Schema and its Online Catalog (OC) SubschemaAll scripts necessary to create this schema reside in $ORACLE_HOME/demo/schema/order_entry. You need to call only one script, oe_main.sql, to create all objects and load the data. Running oe_main.sql accomplishes the following tasks: Prompts for passwords and tablespace names used within the scripts Erases any previously installed OE schema Creates the user OE and grants the necessary privileges Connects

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

Making Queries Using Source Methods, 4 of 8

Values Ranked in the Same or the Opposite Order as the Values of Another SourceYou can rank the values of a Source by sorting them in the same or the opposite order of the values … order as the Source named sortValue. Example 6-10 the values of a Source named base in the opposite … order as the Source named sortValue. Example 6-9 Ranking Values in the Same Order as Another Source … Opposite

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Customizing Locale Data

Changing the Sort Order for All Characters with the Same DiacriticThis example shows how to change the sort order for characters with diacritics. You can do this by … after all characters containing a tilde. Verify the current sort order by choosing Canonical Rules … shows the Non-Spacing Characters screen. Figure 12-30 Changing the Sort Order for All Characters with … Secondary in the Paste

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Capacity Planner Messages

VTP-0110: In order to collect historical data, at least one data item non-key column must be selected.Cause: An attempt was made to create a user-defined class with only one column in the class. This column is used as the key, resulting in no data items in the class. Action: Add at least one other data item to the class for collection.

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

Summary of the Supplier: Top Level Order Process (Oracle Workflow Help)

Oracle Workflow Guide Release 2.6.2                              Contents   Index   Glossary Master Index Feedback

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

Summary of the Supplier: Get Order Details Subprocess (Oracle Workflow Help)

Oracle Workflow Guide Release 2.6.2                              Contents   Index   Glossary Master Index Feedback

Enterprise Manager Database Tuning with the Oracle Tuning Pack, 9i Release 2 (9.2.0.2)

Introduction to the Outline Editor

Changing the Join OrderThe Join Order of an explain plan tells the optimizer how to join multiple tables within a single … the join order by allowing you to drag and drop a table to another position or by selecting the Outline\\Join Order menu option.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-22950 cannot ORDER objects without MAP or ORDER methodCause: An object type must have a MAP or ORDER method defined for all comparisons other than … equality and inequality comparisons. Action: Define a MAP or ORDER method for the object type.

Error Messages, 9i Release 2 (9.2.0.2)

Recovery Manager Messages (RMAN)

RMAN-20036 invalid record orderCause: This is an internal error. Action: Contact Oracle Support Services.

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

Preface

How to Order this ManualIn North America, printed documentation is available for sale in the Oracle Store at http://oraclestore.oracle.com/ Customers in Europe, the Middle East, and Africa (EMEA) can purchase documentation from http://www.oraclebookshop.com/ Other customers can contact their Oracle representative to purchase printed documentation. To download free release notes, installation documentation, white papers,

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

OPTION *OR * ORDER *

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-01424 Non-ANSI order of clausesfrom clause must come first, and the clauses after it can appear in any order (with the addition of

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00000 to ORA-00899

ORA-00355 change numbers out of orderCause: A change number found in the redo log is lower than a previously encountered change number. The log is corrupted in some way. The corruption may be at the earlier change or at this one. Action: Perform recovery with a good version of the log or perform time-based recovery up to the indicated time.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30487 ORDER BY not allowed hereCause: DISTINCT functions and RATIO_TO_REPORT cannot have an ORDER BY clause.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-22951 NULL returned by ORDER methodCause: ORDER method used to compare two object values returned NULL which is not allowed. Action: Redefine the ORDER method to not return a NULL.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-10839 invalid ORDER argument supplied to NEARCause: An invalid value was supplied for ORDER argument to NEAR. Action: Provide a valid ORDER. Valid values are T, TRUE, F, FALSE (case insensitive).

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-02282 duplicate or conflicting ORDER/NOORDER specificationsCause: Duplicate or conflicting ORDER and/or NOORDER clauses were specified. Action: Remove one of the conflicting specifications and try again.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00650 invalid type for PARTITION/CLUSTER/ORDER BY clauseCause: An attempt was made to use an invalid type for either PARTITION BY, ORDER BY, or CLUSTER BY clauses. Action: Use legal, allowed types.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30485 missing ORDER BY expression in the window specificationCause: Either the ORDER BY expression is mandatory for this function, or there is an aggregation group without any ORDER by expression.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00523 ORDER methods must return an INTEGER.Cause: An order member function was written such that it returns something other than an integer … type. Action: Rewrite the ORDER method such that it returns an integer type.

Error Messages, 9i Release 2 (9.2.0.2)

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

QSM-02044 ORDER BY clause in materialized viewCause: The capability in question is not supported when the materialized view includes an ORDER BY clause. Action: Remove the ORDER BY clause.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-29301 wrong DBMS_PITR package function/procedure orderCause: The DBMS_PITR package function/procedure was called in an incorrect order. Action: Restart tablespace point-in-time recovery with a correct procedure.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30929 ORDER SIBLINGS BY clause not allowed hereCause: ORDER SIBLINGS BY clause is specified in a query which doesn't have CONNECT BY clause … . Action: Remove ORDER SIBLINGS BY clause or add CONNECT BY clause.

Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

SyntaxNEAR(( word1, word2,..., wordn ) [, max_span [, order]])

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

Queued Shipping (QS) Schema ScriptsThis section shows the QS schema scripts in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Solaris Event Tests

Descriptions of Solaris Event TestsThe Solaris event tests are listed in alphabetical order.

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

Sales History (SH) Schema ScriptsThis section shows the SH schema scripts in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Linux Event Tests

Descriptions of Linux Event TestsThe Linux event tests are listed in alphabetical order.

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

Human Resources (HR) Schema ScriptsThis section shows the HR schema scripts in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

HP-UX Event Tests

Descriptions of HP-UX Event TestsThe HP-UX Event Tests are listed in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

IBM AIX Event Tests

Descriptions of IBM AIX Event TestsThe IBM AIX Event Tests are listed in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Compaq Tru64 Event Tests

Descriptions of Compaq Tru64 Event TestsThe Compaq Tru64 Event Tests are listed in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Windows NT Event Tests

Descriptions of Windows NT Event TestsThe Windows NT event tests are listed in alphabetical order.

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

Product Media (PM) Schema ScriptsThis section shows the PM schema scripts in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

HTTP Server Event Tests

Descriptions of HTTP Server Event TestsThe HTTP Server event tests are listed in alphabetical order.

Event Test Reference Manual, 9i Release 2 (9.2.0.2)

Oracle Database Event Tests

Descriptions of Database Event TestsThe Oracle Database Event Tests are listed in alphabetical order.

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.AQ

getSortOrderpublic java.lang.String getSortOrder() throws AQException This method gets the sort order that is used. Returns The sort order used

Error Messages, 9i Release 2 (9.2.0.2)

ORA-12700 to ORA-19399

ORA-14303 partitions or subpartitions are not in the right orderordered differently from the DDL order of partitions or subpartitions. Action: Re-order the partitions … or subpartitions in the added LOB storage clause by partition or subpartition DDL order, and retry the statement.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00625 PARTITION/CLUSTER/ORDER-BY clause can only be used with IN parametersCause: A PARTITION/CLUSTER/ORDER-BY clause was used with an OUT or IN OUT ref-cursor parameter … . Action: Change the parameter mode to IN or use some other parameter with the PARTITION/CLUSTER/ORDER-BY clause.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00654 PARTITION/ORDER/CLUSTER BY is only allowed for with PARALLEL_ENABLECause: An attempt was made to use either PARTITION BY, ORDER BY, or CLUSTER BY clauses without … parallel enable clause in table function. Action: Specify parallel enable also when using PARTITION BY, CLUSTER BY, or ORDER BY clauses.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-01500 to ORA-02099

ORA-01785 ORDER BY item must be the number of a SELECT-list expressionCause: Either an ORDER BY item for a set expression is not a column number, or the ORDER BY item is … not the number of a SELECT list column. Action: The ORDER BY item must be a number between 1 and

Error Messages, 9i Release 2 (9.2.0.2)

ORA-09858 to ORA-12299

ORA-10589 Test recovery had to corrupt string data blocks in order to proceedblocks as specified in the message in order to apply the range of redo tested. Action: See the alert log for details of the problems.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00527 MAP or ORDER functions require a PRAGMA RESTRICT_REFERENCES specifying :WNDS,WNPS,RNPS,RNDS.Cause: Either a PRAGMA RESTRICT_REFERENCES was not specified or it was specified without one of the following: WNDS, WNPS, RNPS, or RNDS. Action: Add or correct the PRAGMA and retry the operation.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00528 The parameters to an ORDER function must have IN modeCause: A parameter was declared to an ORDER function to have OUT or IN OUT mode. Action: Correct the parameter to use IN mode only.

SQL Reference, 9i Release 2 (9.2.0.2)

Preface

Chapters 9 through 18 list and describe all Oracle SQL statements in alphabetical order.Appendix A, \"How to Read Syntax Diagrams\" This appendix describes how to read the syntax diagrams in this reference. Appendix B, \"Oracle and Standard SQL\"

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30435 job_queue_processes must be non-zero in order to refresh summariesCause: The server must be started with parameter JOB_QUEUE_PROCESSES greater than zero. Action: Correct the value of JOB_QUEUE_PROCESSES and restart the server instance.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-09858 to ORA-12299

ORA-10586 Test recovery had to corrupt 1 data block in order to proceedCause: This message summarizes test recovery result: Oracle may have to corrupt one block in order

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00646 MAP or ORDER method must be defined in the root of the subtype hierarchyCause: An attempt was made to define a MAP or ORDER method in a subtype. Action: Define the MAP or … ORDER method in the root of the subtype hierarchy. You can override MAP methods in subtypes.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-19611 backup piece out of order. Expected string but found stringCause: This backup piece is out of sequence. Action: Supply the correct backup piece.

Error Messages, 9i Release 2 (9.2.0.2)

External Tables Messages (KUP)

KUP-04091 little endian byte order mark found when big endian expected in stringCause: A little endian byte order mark was found at the beginning of the specified file. Either the … access parameters specified that the data was in big endian order or the byte order mark for a … previous file was big endian. Action: The file needs to be loaded separately. If a byte order was

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00526 A MAP or ORDER function is required for comparing objects in PL/SQL.Cause: Within stand alone PL/SQL, an attempt was made to compare objects without a map or order … function. Action: Provide a map or order function and retry the operation.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-02813 Unable to make temporary file name in order to get keyCause: This is an internal error. Action: Contact Oracle Support Services.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-10846 order by columns must be all ascending or all descendingCause: An ORDER BY clause was specified which has some columns ascending and some descending. This is not currently supported by CATSEARCH. Action:

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00155 Only a function may be a MAP, ORDER or CONSTRUCTOR method.Cause: A procedure was declared as a MAP, ORDER, or CONSTRUCTOR method. Only functions can be MAP … , ORDER, or CONSTRUCTOR methods. Action: Change the procedure to a function.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00423 ORDER BY item must be the number of a SELECT-list expressionCause: A column alias was used in the ORDER BY clause of a SELECT statement that uses a UNION … , INTERSECT, or MINUS set operator. This is not allowed. In such cases, expressions in the ORDER BY clause … the alias in the ORDER BY clause to an unsigned integer that designates the ordinal position of the select item in question.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-19400 to ORA-24279

ORA-22315 type \" string \" does not contain a map or order functionCause: The input type does not contain a map or order function so one cannot be returned. Action … : Add a map or order function to the type or catch this error.

Error Messages, 9i Release 2 (9.2.0.2)

External Tables Messages (KUP)

KUP-04090 big endian byte order mark found when little endian expected in stringCause: A big endian byte order mark was found at the beginning of the specified file. Either the … access parameters specified that the data was in little endian order or the byte order mark for a … previous file was little endian. Action: The file needs to be loaded separately. If a byte order was

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00154 An object type may have only 1 MAP or 1 ORDER method.Cause: More than one map or order function was declared. An object type can have only one map … function or one order function, but not both. Action: Delete all but one of the MAP or ORDER functions on the type.





Was this page helpful?

Integrated Cloud Applications & Platform Services