Results for ORDER


201 to 240 of 2659 results. Prev  Next
Results per page:  20 |  40  | 60


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

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

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

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\");

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.

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

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

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

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\".

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

Handle and Descriptor Attributes

Descriptionwhen the order in which the objects are flushed is not important. During this mode it is not … guaranteed that the order in which the objects are marked dirty is preserved. See Also: \"Object Cache

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

XML Parser for C

getElementsByTagName()tag name in the order in which they would be encountered in a pre-order traversal of the tree. If

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

SQL*Plus Error Messages

CPY0004 Source and destination table and column names don't matchtheir respective order in the destination table match the column names and column order in the optional column list or in the SELECT command

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

Sample PL/SQL Programs

Input TablesSQL> SELECT * FROM accounts ORDER BY account_id; ACCOUNT_ID BAL ---------- ------- 1 1000 2 2000 3 … 1500 4 6500 5 500 SQL> SELECT * FROM action ORDER BY time_tag; ACCOUNT_ID O NEW_VALUE STATUS

Configuration Guide, 9i Release 2 (9.2.0.2)

Troubleshooting

Setting the Format of DatesTo set up how the order of the date elements are to be displayed in the Oracle Enterprise Manager … up the order in which the elements are to be displayed; you cannot set up what is to be displayed.

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

Pipelined and Parallel Table Functions

Input Data Streaming for Table Functionsrestriction on the ordering of the incoming rows Order them on a particular key column or columns … the following syntax: FUNCTION f(p ) RETURN tab_rec_type [PIPELINED] {[ORDER | CLUSTER] BY … specified for either sequential or parallel execution of a function. If an ORDER BY or CLUSTER BY clause … is not specified, rows are input

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

PL/SQL Subprograms

Using Named Notationparameter pairs in any order. So, you need not know the order in which the formal parameters are listed.

Reference, 9i Release 2 (9.2.0.2)

Initialization Parameters, 74 of 222

HI_SHARED_MEMORY_ADDRESSspecify the high-order 32 bits of a 64-bit address. Use SHARED_MEMORY_ADDRESS to specify the low-order

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

Basic Components of Oracle Objects

Methods for Comparing ObjectsThe values of a scalar datatype such as CHAR or REAL have a predefined order, which allows them to … various datatypes, has no predefined axis of comparison. To be able to compare and order variables of an … defined for doing this: map methods and order methods. Map Methods A map method is an optional kind … , you can order

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

A Sample Application Using AQ

A Sample Applicationsystem is an order entry application used to enter new orders. Incoming orders are processed by an order … processing application that validates and records the order. Shipping departments located at … shipping international orders. After an order is shipped, the order information is routed to a central

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

Buyer: Receive Supplier Invoicing Subprocess Activities (Oracle Workflow Help)

Buyer: Receive Supplier Invoicing Subprocess ActivitiesActivity Event Name, Event Key, Event Message Invoice for Order Has Arrived (Node 3) This activity … notifies the order requestor that the invoice for the purchase order has been received from the … supplier. The message includes a 'Send' attribute that displays the purchase order number when the … assigned to

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

Creating Applications Using JMS

A Sample Application Using JMSend of the system is an order entry application where new orders are entered. These incoming orders … are processed by an order processing application that validates and records the order. Shipping … serving the West Region, and a third warehouse for shipping International orders. Once an order has been … shipped,

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

A Sample Application Using AQ

Message Transformation During EnqueueContinuing the scenario introduced in \"Message Format Transformation\", the Order Entry and … Shipping applications have different representations for the order item. The order entry application … represents the order item in the form of the ADT OE.order_typ. The Western shipping application … represents the

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

A Sample Application Using Object-Relational Features

Entities and Relationships… A customer has a one-to-many relationship with a purchase order: a customer can place many orders … , but a given purchase order is placed by one customer. Because a customer can be defined before he … places an order, the relationship is optional rather than mandatory. Similarly, a purchase order has

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Locale Data

Linguistic SortingGeneric sorting order which is based on ISO14651 and Unicode canonical equivalence rules but excluding … compatible equivalence rules JAPANESE_M Japanese sort supports SJIS character set order and EUC … binary order. Hanja characters based on pronunciation order. All Hangul characters are before Hanja … based

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

A Sample Application Using AQ

Priority and Ordering of MessagesThe message ordering dictates the order that messages are dequeued from a queue. The ordering … , enqueue time as the sort order for the message. If priority ordering is chosen, each message will … dequeued in the order of the priorities assigned. If two messages have the same priority, the order in … can also

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

Creating Applications Using JMS

Priority and Ordering of MessagesThe message ordering dictates the order in which messages will be received from a queue or topic … messages are received in the order of the enqueue time. The enqueue time is assigned to the message by … the order of the priorities assigned. First-In, First-Out (FIFO) Priority Ordering A FIFO-priority … topic/queue can also be

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Byte Orderingthe byte order of the system where it is running as the byte order for all datafiles. For example, on … a Sun Solaris system, SQL*Loader uses big endian byte order. On an Intel or an Intel-compatible PC … , SQL*Loader uses little endian byte order. Byte order affects the results when data is written

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

A Sample Application Using AQ

Time Specification: Expirationamount of time that is allowed to process a back order. The shipping application places orders for … books that are not available on a back order queue. If the shipping policy is that all back orders must … be shipped within a week, then messages can be enqueued into the back order queue with an expiration … not been shipped according

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 46 of 177

FIRST_VALUEthe lowest salary. SELECT departmeent_id, last_name, salary, FIRST_VALUE(last_name) OVER (ORDER BY … = 90 ORDER BY employee_id); DEPARTMENT_ID LAST_NAME SALARY LOWEST_SAL … ordered by employee_id in descending order, as in the next example, then the function returns a … different value: SELECT department_id, last_name, salary,





Was this page helpful?

Integrated Cloud Applications & Platform Services