Results for ORDER


161 to 220 of 2659 results. Prev  Next
Results per page:  20 | 40 |  60 


Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05549 Error: NULL connect request in fileorder to initiate a load of the historical data. Action: contact Oracle Support Services.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05551 Error: failed to sync data fileorder to initiate a load of the historical data. Action: contact Oracle Support Services.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05815 Error: connect_req ack or connect_service ack expectedCause: error during recovery of State file, messages out of order Action: Restart the Data Gatherer

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

Troubleshooting

sqlnet.ora : File with SQL*Net specific parameters1 file per $ORACLE_HOME Located in either (using this order searching for it): $TNS_ADMIN /etc or /var/opt/oracle $ORACLE_HOME/network/admin

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

DBMS_DESCRIBE, 2 of 2

Return ValuesPL/SQL tables, in order to accommodate a variable number of parameters.

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

Package oracle.xml.parser.v2

getMessage()Description Overrride getMessage, in order to construct error message from error id, and error

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05543 Error: failed to write loader informationorder to initiate a load of the historical data. Action: contact Oracle Support Services.

Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

Group 2 Operators and CharactersWithin query expressions, the Group 2 operators have the following order of evaluation from highest

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

Image process( ) and processCopy( ) Operators

D.4.1 ChannelOrderThe ChannelOrder operator determines the relative order of the red, green, and blue channels (bands … ) within the destination Raw Pixel image. The order of the characters R, G, and B within the … mnemonic value passed to this operator determine the order of these channels within the output. The header … of the Raw Pixel image

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

Exceptions and Error Messages

IMG-00550,\"invalid scanlineOrder specified\"Cause: The specified scanline order was not valid. Action: Refer to Oracle interMedia User's Guide

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

Linear Referencing Functions

SDO_LRS.CONVERT_TO_STD_LAYER   Converts all geometry objects in a column of type SDO_GEOMETRY from Linear…provides reference information on the functions, listed in alphabetical order.

Reference, 9i Release 2 (9.2.0.2)

CONTAINS Query Operators

Operator PrecedenceOperator precedence determines the order in which the components of a query expression are … evaluated. Text query operators can be divided into two sets of operators that have their own order of … are evaluated in order from left to right according to the precedence of their operators. Operators … with higher precedence are applied

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

\"To Initiate the Event System Demonstration Workflow from the Buyer Workbench (Oracle Workflow Help)

To Initiate the Event System Demonstration Workflow from the Buyer Workbenchbe prompted to do so before the page appears. 2. Enter a unique order number for the purchase order … . The order number becomes the event key for the B2B Purchase Order event that is raised. 3. Select an … format DD-MON-YYYY. 6. Enter the total amount for the purchase order. The amount should be a number

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05538 Error: failed to write credential informationorder to initiate a load of the historical data. Action: contact Oracle Support Services.

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

DBMS_APPLY_ADM, 2 of 2

EXECUTE_ALL_ERRORS Procedurereexecuted in commit SCN order. Error reexecution stops if an error is raised.

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

Event System Demonstration (Oracle Workflow Help)

Event System Demonstrationtwo systems. You initiate the demonstration process by entering a purchase order on one system … . Oracle Workflow generates a purchase order XML document and sends this document to a second system. The … second system processes the purchase order and sends back to the first system three XML documents … representing a purchase

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

\"To Continue the Event System Demonstration Workflow on the Supplier System (Oracle Workflow Help)

To Continue the Event System Demonstration Workflow on the Supplier SystemWorkflow in your Web server. See: Setting Global User Preferences. Choose the Events: Track Order link to … display the Events: Track Order web page. Alternatively, you can enter the following URL to directly … be prompted to do so before the page appears. 2. Select the order number for your purchase order … and

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

Package oracle.AQ

setSortOrderorder to be used. Parameter Description s_order specifies the columns to be used as the sort_key in … ascending order; the string has the format. the allowed columns name are priority and enq_time.

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

Sample PL/SQL Programs

Output TablesSQL> SELECT * FROM accounts ORDER BY account_id; ACCOUNT_ID BAL ---------- ------ 1 700 2 1400 3 … 1500 4 6500 5 500 SQL> SELECT * FROM journal ORDER BY date_tag; ACCOUNT_ID ACTION AMOUNT DATE_TAG

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

Maintaining Data Integrity Through Constraints

Rules for Multiple CHECK Constraintsorder in which the constraints are evaluated is not defined, so be careful not to rely on the order

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

JAI Input and Output Stream Reference Information

bThe byte to be written to the BLOB. Only the low-order byte is written; the upper 24 bits are … integer whose low-order byte will be written to the BLOB. Copyright © 1999, 2002 Oracle Corporation

Reference, 9i Release 2 (9.2.0.2)

CTX_THES Package

Notes: begin CTX_THES.CREATE_RELATION('thes','dog','BT','animal'); end; Note: The order in which you … specify arguments for CTX_THES.CREATE_RELATION is different from the order you specify them with CTX_THES.CREATE_PHRASE.

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

Package oracle.xml.parser.v2

getLength()The SAX parser may provide attributes in any arbitrary order, regardless of the order in which they

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

Selecting Data, 2 of 13

Changing the Current Status Listvalues and the order of the values in the current status list of a dimension. The SORT command to … arrange the order of values in the current status list of a dimension.

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

Hypothetical Rank and Distribution Syntax[RANK | DENSE_RANK | PERCENT_RANK | CUME_DIST]( constant expression [,...] ) WITHIN GROUP ( ORDER … BY order by expression [ASC|DESC] [NULLS FIRST|NULLS LAST][,...] ) Here, constant expression refers … are passed as arguments to the function. The ORDER BY clause can contain one or more expressions … that define the sorting order

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

SQL*Plus Command Reference

Examples, COMMISSION_PCT FROM EMP_DETAILS_VIEW To add an ORDER BY clause to the query, enter LIST 2 2* FROM … EMP_DETAILS_VIEW INPUT ORDER BY LAST_NAME LIST 2 ensures that line 2 is the current line. INPUT adds a new … line containing the ORDER BY clause after the current line. The SQL buffer now contains the … following lines: 1 SELECT

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

Query Optimization

Predicate Orderingkeys) are evaluated in the order specified by the following rules: Predicates without any user … -defined functions, type methods, or subqueries are evaluated first, in the order specified in the WHERE … evaluated in increasing order of their cost. Predicates with user-defined functions and type methods … that have no user-computed

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

Buyer: Receive Supplier PO Acknowledgement Subprocess Activities (Oracle Workflow Help)

Buyer: Receive Supplier PO Acknowledgement Subprocess Activitiesevent activity waits to receive the B2B Purchase Order Acknowledgement event message from the supplier … the order requestor that the supplier has not yet acknowledged the purchase order. The message … includes a 'Send' attribute that displays the purchase order number when the notification is sent. If you … performer

Java Stored Procedures Developer's Guide, 9i Release 2 (9.2.0.2)

Developing an Application

Drawing the Entity-Relationship Diagram… Figure 5-2 E-R Diagram for Purchase Order Application Text description of the illustration entity_a.gif … A Customer has a one-to-many relationship with a Purchase Order because a customer can place many … orders, but a given purchase order can be placed by only one customer. The relationship is optional … because zero

Utilities, 9i Release 2 (9.2.0.2)

External Tables Concepts

External Table Restrictionsquery does not reference that column. Handling of byte-order marks during a load - in an external … checking for byte-order marks. Suppression of byte-order mark checking is only necessary if the … beginning of the datafile contains binary data that matches the byte-order mark encoding. (It is possible to … suppress

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

Case Study 10: Loading REF Fields and VARRAYsCase 10 demonstrates: Loading a customer table that has a primary key as its OID and stores order … items in a VARRAY. Loading an order table that has a reference to the customer table and the order

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

Design Considerations for Oracle Objects

Performance of Object ComparisonsYou can compare objects by invoking the map or order methods defined on the object type. A map … order objects once they are mapped. The way objects are mapped has significant performance implications … when sorting is required on the objects for ORDER BY or GROUP BY processing because an object may … cannot be mapped into scalar

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

Troubleshooting

Files Used During DiscoveryLocated in either (using this order searching for it): $TNS_ADMIN in the environment $TNS_ADMIN in the registry $ORACLE_HOME\\network\\admin

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

Troubleshooting

snmp_rw.ora : File with all updateable service information1 per Intelligent Agent Located in either (in order according to search priority): $TNS_ADMIN in

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

Roadmap to Building a Data Cartridge

Cartridge RegistrationIn order to make a naming scheme work, you need to have a registration process that will handle the

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Schemas Used in Performance Examples

SO_HEADERS_ALL and SO_HEADERS TablesThis table has a row for every order on the system. For large companies, it is common to have … placing the order) purchase_order_num (the purchase order for billing) original_system_reference … (tracks the order identifier for orders imported from other systems) The following are indexes on the

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

Troubleshooting

Files Used During Discovery on UNIXof the following locations (using this order searching for it): $TNS_ADMIN /etc or /var/opt/oracle $ORACLE_HOME/network/admin

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

Troubleshooting

snmp_ro.ora : File with all read-only service information1 per Intelligent Agent Located in either (in order according to search priority): $TNS_ADMIN in

Concepts Guide, 9i Release 2 (9.2.0.2)

Using Multiple Oracle Homes

Target Homedeinstallation is the target home. In order to upgrade or remove products from the target homes, those products must be shut down/stopped.

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

Package oracle.xml.async

Package oracle.xml.async Summarywhich is sent when parse exception occurs. DOMBuilderErrorListener Implemented in order to receive … notify all registered listeners about parse events. DOMBuilderListener Implemented in order to receive … This interface must be implemented in order to receive notifications when an error is found during … . XSLTransformerListener

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

DBMS_SHARED_POOL, 2 of 2

Parametersan object must be occupying in the shared pool, in order for it to be displayed.

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Analysis in Data Warehouses

Bottom N Rankingprevious example, you can order SUM(s_amount) ascending instead of descending.

Migration, 9i Release 2 (9.2.0.2)

Upgrading an Oracle7 Database Using the MIG Utility

Troubleshooting MIG Utility ErrorsErrors may be caused by the following actions or omissions: Performing an upgrade step out of order

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

Case Study 11: Loading Data in the Unicode Character Setcharacter set. Using character-length semantics. Using SQL*Loader to load data in little endian byte order … . SQL*Loader checks the byte order of the system on which it is running. If necessary, SQL*Loader … swaps the byte order of the data to ensure that any byte-order-dependent data is correctly loaded.

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

Package oracle.xml.async

DOMBuilderErrorListenerjava.util.EventListener Description This interface must be implemented in order to receive

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

Package oracle.xml.async

DOMBuilderListenerjava.util.EventListener Description This interface must be implemented in order to receive notifications

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

Package oracle.xml.async

XSLTransformerListenerjava.util.EventListener Description This interface must be implemented in order to receive

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

A Sample Application Using Object-Relational Features

Updating Data Under The Relational ModelPurchase Order 1001 and Stock Item 1534 UPDATE LineItems_reltab SET Quantity = 20 WHERE PONo = 1001 AND StockNo = 1534;

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

Handle and Descriptor Attributes

Descriptionsatisfies the pattern, the order of dequeuing is undetermined.

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

Oracle Internet Directory Server Plug-in Framework

Prerequisite KnowledgeIn order to develop Oracle Internet Directory plug-ins you should be familiar with: Generic LDAP

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

Reference: Extensible Optimizer Interface

ORDERED_PREDICATES HintThe hint ORDERED_PREDICATES forces the optimizer to preserve the order of predicate evaluation

Advanced Replication, 9i Release 2 (9.2.0.2)

Planning Your Replication Environment

Designing a Replication Environment for Survivability, for example, you are running an order-entry system that uses replication to maintain a remote fail … over order-entry system, and the primary system fails. At the time of the failure, there were two … applied at the failover site. The first of these was a transaction that entered a new order, and the … second was a transaction

Configuration Guide, 9i Release 2 (9.2.0.2)

Activating Logging and Tracing

Logging and Tracing of the Event HandlerThe Event Handler is part of the Oracle Management Server. In order to trace the Event Handler … \", for more information about the properties and values to add to the OMSCONFIG.PROPERTIES file in order to enable tracing.

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

Reference Information

Outer Joins} ORDER BY ename\"); Use Oracle SQL syntax: Statement stmt = conn.createStatement (); ResultSet rset … = stmt.executeQuery (\"SELECT ename, dname FROM emp a, dept b WHERE a.deptno = b.deptno(+) ORDER BY ename\");

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

SQL*Plus Command Reference

ExamplesEMP_DETAILS_VIEW WHERE JOB_ID = 'SA_MAN' ORDER BY DEPARTMENT_ID; To make the line containing the WHERE clause … now contains the following lines: SELECT LAST_NAME, DEPARTMENT_ID FROM EMP_DETAILS_VIEW ORDER BY

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

Selecting Data, 6 of 13

How Limiting to a Related Dimension Determines Statusprocess: The values in the dimension current status list are arranged in the order of the values of … related dimension, then the values in the dimension current status list are arranged in the order of their default status list.

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

Design Considerations for Oracle Objects

Changing Default ConstructorsWhen a type is altered, its default, system-defined constructors need to be changed in order (for … constructors, you need to modify their invocations in your program in order for the calls to compile. You can

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

PL/SQL Subprograms

How Table Functions Stream their Input Datarestriction on the ordering of the incoming rows Order them on a particular key column or columns … the ORDER BY or CLUSTER BY clauses when defining the function. Input streaming can be specified for … either sequential or parallel execution of a function. If an ORDER BY or CLUSTER BY clause is not … specified, rows are input

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

Buyer: Send PO to Supplier Subprocess Activities (Oracle Workflow Help)

Buyer: Send PO to Supplier Subprocess Activities… At this node, the process retrieves the name of the order requestor from the purchase order event … Attributes Retrieved by Function Event Message Item Attributes Set by Function Order Requestor … Buyer: Send PO to Supplier (Node 3) This event activity sends the purchase order event message to the

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

Basic Components of Oracle Objects

Collectionsgive a purchase order object type a nested table attribute to hold the collection of line items for a given purchase order. See Also: \"Collections\".





Was this page helpful?

Integrated Cloud Applications & Platform Services