Results for ORDER


81 to 140 of 2659 results. Prev  Next
Results per page:  20 | 40 |  60 


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

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)

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)

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)

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.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00521 ORDER methods must be declared with 1 (one) parameter in addition to (optional) SELF.Cause: An order member function was declared without the user-specified parameter. Order member … second parameter is added by the user and must declare an order method which must be the same type as

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00524 The parameter type in an ORDER method must be the containing object type.Cause: An order member function was declared without the user- specified parameter. Order member … second parameter is added by the user and must declare an order method which must be the same type as

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01409 NOSORT option may not be used; rows are not in ascending orderonly be used for indexes on groups of rows that already are in ascending order. For non-unique indexes … ascending order may not be. If you create an index NOSORT, and two of the rows in the table have the … these addresses are not in ascending order, the ROWIDs are not either. Since these ROWIDs are … considered part of the index

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

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

Working with Labeled Data

Ordering by Character Representation of LabelUsing the LABEL_TO_CHAR function, you can order data rows by the character representation of the … label. For example, the following statement returns all rows sorted by the text order of the label: SELECT * FROM emp ORDER BY label_to_char (hr_label);

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

Management Pack for Oracle Applications Event Tests

Descriptions of Applications Event Tests for V8.1.6 and Earlier AgentsThe Applications event tests for v8.1.6 and earlier agents are listed in alphabetical order.

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

Management Pack for Oracle Applications Event Tests

Descriptions of Applications Event TestsThe Applications event tests for release 9 i are listed in alphabetical order.

Performance Planning, 9i Release 2 (9.2.0.2)

Oracle9i Database Performance Planning -- Index

Ccolumn order, 1-17 conceptual modeling, 2-12 CPUs, 1-8 statistics, 2-2

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

SQLJ Error Messages

You are using a non-Oracle JDBC driver to connect to an Oracle database. Only JDBC-generic checking…Cause: In order to perform Oracle-specific checking, an Oracle JDBC driver is required.

Pro*Fortran, 9i Release 2 (9.2.0.2)

Operating System Dependencies

System-Specific ReferencesThe references in this section appear using similar order and headings.

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

Package oracle.XML.parser.schema

getOrder()Description Get the composite type - ALL, SEQUENCE, or CHOICE Syntax public int getOrder() Returns order

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

Oracle Database Event Tests

Data Sourceselect name, ready from gv$aq g,all_queues d where g.qid = d.qid order by name

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

Oracle Database Event Tests

Data SourceSelect name, expired from gv$aq g,all_queues d where g.qid = d.qid order by name

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

Oracle Database Event Tests

Data SourceSelect name, waiting from gv$aq g,all_queues d where g.qid = d.qid order by name.

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

System-Specific References

Byte OrderingThe order of bytes in a word is platform dependent. See the section \"UNSIGNED\".

Reference, 9i Release 2 (9.2.0.2)

SQL Statements and Operators

NotesThe SCORE operator can be used in a SELECT, ORDER BY, or GROUP BY clause.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-09858 to ORA-12299

ORA-10563 Test recovery had to corrupt data block file# string, block# string in order to proceedCause: Test recovery completed. Action: No action is needed. Test recovery has ended successfully. See other messages on error stack for a summary of the result of the test recovery.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00664 Both ORDER BY and CLUSTER BY can not be specified for the same table functionCause: An attempt was made to specify both ORDER BY and CLUSTER BY for the same table function … . Action: Specify either ORDER BY or CLUSTER BY for a table function, but not both.

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00525 Within SQL statements, only equality comparisons of objects are allowed without a map or order…Cause: A map or order function was not provided for a relational comparison. Only equality … comparisons may be used when a map or order function is not supplied. Action: Supply either a map or order

Error Messages, 9i Release 2 (9.2.0.2)

PL/SQL and FIPS Messages (PLS)

PLS-00631 PARTITION-BY and CLUSTER/ORDER-BY clauses must be used with the same function argumentCause: PARTITION-BY and CLUSTER/ORDER-BY clauses are specified on different function arguments … . Action: Use the same argument in both PARTITION-BY and CLUSTER/ORDER-BY clauses.

Enterprise Manager Getting Started with the Oracle Diagnostics Pack, 9i Release 2 (9.2.0.2)

Introduction to Oracle Performance Manager

Sorting Data in a Table ChartWhen a chart is displaying data in table format, the sort order of the column data can be changed … ascending order, and a second click sorts the data in descending order. Changing the sort order in the … chart table does not affect the data's sort order on the server. To change the sort order

Enterprise Manager Getting Started with the Oracle Standard Management Pack, 9i Release 2 (9.2.0.2)

Introduction to Oracle Performance Manager

Sorting Data in a Table ChartWhen a chart is displaying data in table format, the sort order of the column data can be changed … ascending order, and a second click sorts the data in descending order. Changing the sort order in the … chart table does not affect the data's sort order on the server. To change the sort order

Enterprise Manager Getting Started with the Oracle Management Pack for Oracle Applications, 9i Release 2 (9.2.0.2)

Introduction to Oracle Performance Manager

Sorting Data in a Table ChartWhen a chart is displaying data in table format, the sort order of the column data can be changed … ascending order, and a second click sorts the data in descending order. Changing the sort order in the … chart table does not affect the data's sort order on the server. To change the sort order

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

FIRST/LAST SyntaxThese functions have the following syntax: aggregate_function KEEP ( DENSE_RANK LAST ORDER BY expr … query_partitioning_clause] Note that the ORDER BY clause can take multiple expressions.

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

A Sample Application Using Object-Relational Features

Implementing the Schema on the Relational ModelThis section implements the relational version of the purchase order schema depicted in Figure 9-1 … . Figure 9-1 Entity-Relationship Diagram for Purchase Order Application Text description of the illustration adobj001.gif

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

Sample PL/SQL Programs

Input TableSQL> SELECT * FROM accounts ORDER BY account_id; ACCOUNT_ID BAL ---------- -------- 1 1000 2 2000 3 1500 4 6500 5 500

Oracle Database, 9i Release 2 (9.2.0.2)

Oracle9i Database Documentation Readme

Ordering Hard Copy Documentation or CDsTo order printed documentation or additional copies of this CD, visit the online Oracle Store at http://oraclestore.oracle.com/

Net Services Reference Guide, 9i Release 2 (9.2.0.2)

Profile Parameters (sqlnet.ora)

NAMES.DIRECTORY_PATHPurpose Use the parameter NAMES.DIRECTORY_PATH to specify the order of the naming methods used for client name resolution lookups.

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 42 of 59

RequirementsExecute this command only at the RMAN prompt. You must have a maintenance channel allocated in order to release it.

Enterprise Manager Getting Started with the Oracle Diagnostics Pack, 9i Release 2 (9.2.0.2)

Using Oracle Trace Data Viewer

Data value columnsThe columns are displayed in the sort order determined by the value in the column marked with asterisk (*).

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 6 of 19

ExampleDropping a Trigger: Example The following statement drops the order trigger in the schema oe: DROP TRIGGER hr.salary_check;

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

Oracle9iAS Release 2 (9.0.2) Event Tests

Descriptions of Oracle9 i AS Release 2 (9.0.2) Event TestsThe Oracle9 i AS Release 2 (9.0.2) event tests are listed in alphabetical order within target type.

XML API Reference - XDK and Oracle XML DB, 9i Release 2 (9.2.0.2)

XML Parser for C

getDocOrder()Description Returns the document order cardinal for a node. setDocOrder() must have been called … first or all nodes will have a 0 order. This function is used primarily by the XSLT processor. Syntax … ub4 getDocOrder( xmlnode *node); Parameter IN / OUT Description node (IN) Node whose doc order to return.

Data Mining Concepts, 9i Release 2 (9.2.0.2)

Basic ODM Concepts

1.8.1 Numerical and Categorical Attributesvalues of an attribute have a certain order. Values of a categorical attribute do not have any … meaningful order; values of a numerical attribute do have a meaningful order. This does not mean that the … values of a categorical attribute cannot be ordered, but rather that the order does not matter. For … example,

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

Summary of the Buyer: Top Level PO Process (Oracle Workflow Help)

Summary of the Buyer: Top Level PO Processyou submit a purchase order from the Buyer Workbench demonstration page, raising the B2B Purchase … Order event. Predefined subscriptions add a correlation ID consisting of the prefix PO followed by the … event key (the order number), and send the event to the Buyer: Top Level PO process. See: To Initiate … the Buyer: Receive

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

Working with Labeled Data

Ordering Labeled Data RowsYou can perform an ORDER BY referencing the policy label column to order rows by the numeric label … tag value which the administrator has set. For example: SELECT * from emp ORDER BY hr_label; Notice

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Queries and Subqueries, 6 of 11

Sorting Query ResultsUse the ORDER BY clause to order the rows selected by a query. Sorting by position is useful in the … following cases: To order by a lengthy select list expression, you can specify its position, rather … than duplicate the entire expression, in the ORDER BY clause. For compound queries (containing set … operators

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 1 of 59

2 RMAN CommandsThis chapter describes, in alphabetical order, Recovery Manager commands and subclauses. For a

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

CONTEXT Query Application

search_html.pspsearch_html Search Search for: Search for: \"> 0 order by score(1) desc

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_MGWADM, 5 of 6

SCHEDULE_PROPAGATION Procedureenabled and the gateway started in order for messages to be propagated.

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

Buyer: Advanced Shipment Notice Subprocess Activities (Oracle Workflow Help)

Buyer: Advanced Shipment Notice Subprocess ActivitiesWF_STANDARD.NOOP Result Type None Prerequisite Activities None Buyer: Purchase Order ASN (Node 2) This … Set by Activity Event Name, Event Key, Event Message Your Order has been Shipped (Node 3) This … activity notifies the order requestor that the purchase order advanced shipment notice has been received … ,





Was this page helpful?

Integrated Cloud Applications & Platform Services