You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for ORDER


1 to 60 of 2545 results. Previous page Prev  Next next page
Results per page:  20 | 40 |  60 


Utilities, 9i Release 2 (9.2.0.2)

External Tables Concepts

Byte-Order Markscontains a byte-order mark (BOM), then the byte-order mark is written at the beginning of the … corresponding bad and discard files. With external table loads, the byte-order mark is not written at the beginning of the bad and discard files.

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Specifying Byte OrderTo specify the byte order of data in the input datafiles, use the following syntax in the SQL … file. It is possible to specify a different byte order for different datafiles. However, the

Administration, 9i Release 2 (9.2.0.2)

Administering Storage Components in Real Application Clusters

The ORDER OptionThe ORDER option of CREATE SEQUENCE guarantees that sequence numbers are generated in the order of … the requests. You can use the ORDER option for time- stamp numbers and other sequences that must … indicate the request order across multiple processes and instances. If you do not need Oracle to issue … sequence

Sample Schemas, 9i Release 2 (9.2.0.2)

Rationale

Order Entry (OE)… Some customers order through the Internet, so email addresses are also recorded. Because of language … and territory of each customer. When a customer places an order, the company tracks the date of the … order, the mode of the order, status, shipping mode, total amount of the order, and the

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Materialized Views

ORDER BY ClauseAn ORDER BY clause is allowed in the CREATE MATERIALIZED VIEW statement. It is used only during the … materialized view in the order specified in the ORDER BY clause. This initial ordering provides physical … due to the physical clustering. The ORDER BY clause is not considered part of the materialized view

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

B2B Purchase Order Event (Oracle Workflow Help)

B2B Purchase Order EventThis event is raised on the Buyer system when you submit a purchase order from the Buyer Workbench … wf_eventdemo.generatexml Oracle Workflow provides four default subscriptions to the B2B Purchase Order event. The … first subscription adds a correlation ID to the event message when the B2B Purchase Order event is … raised locally.

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

Order Entry (OE) Schema ScriptsThis section shows the OE schema scripts in alphabetical order. Note: The scripts starting with

Utilities, 9i Release 2 (9.2.0.2)

External Tables Access Parameters

BYTE ORDER MARK (CHECK | NOCHECK)The BYTE ORDER MARK clause is used to specify whether or not the datafile should be checked for the … presence of a byte-order mark (BOM). BYTE ORDER MARK NOCHECK indicates that the datafile should not … be checked for a BOM and that all the data in the datafile should be read as data. BYTE ORDER MARK … specify

Utilities, 9i Release 2 (9.2.0.2)

Field List Reference

Using Byte Order Marks (BOMs)Datafiles that use a Unicode encoding (UTF-16 or UTF-8) may contain a byte-order mark (BOM) in the … to determine the byte order for all primary datafiles. SQL*Loader reads and interprets the BOM … primary datafile are read and used for checking for byte-order conflicts only. They do not change the … byte-order

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

B2B Purchase Order Acknowledgement Event (Oracle Workflow Help)

B2B Purchase Order Acknowledgement EventThis event is sent from the Supplier system to the Buyer system as a purchase order acknowledgement … after the B2B Purchase Order event is received and processed.   Internal Name … Order Acknowledgement event. The first subscription adds a correlation ID to the event message when … the B2B Purchase Order Acknowledgement

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Operating System Dependencies

Byte-Order of Binary DataOn some platforms such as NT, the COBOL compiler reverses the byte-ordering of binary data. See your platform-specific documentation for the COMP5 precompiler option. Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

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

Tuning Windows NT to Optimize Oracle9i

Reset Network Protocol Bind Orderused by Oracle9 i database highest priority by resetting the network protocol bind order: Choose Start

Utilities, 9i Release 2 (9.2.0.2)

Import

Table Objects: Order of Importin the following order: Type definitions Table definitions Table data Table indexes Integrity … . This sequence prevents data from being rejected due to the order in which tables are imported. This … . When data is imported into existing tables, however, the order of import can still produce referential

Reference, 9i Release 2 (9.2.0.2)

Executables

Order of Precedence for Multiple ThesauriWhen multiple thesauri are to be compiled, precedence is determined by the order in which thesauri

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

Supplier: Get Order Details Subprocess Activities (Oracle Workflow Help)

Supplier: Get Order Details Subprocess Activitiesitem number from the purchase order event message. Function oracle.apps.fnd.wf.XMLGetTagValue Result … node, the process retrieves the item description from the purchase order event message. Function

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

Populating Workspace Data Objects, 3 of 5

Storing Dimension Values in Sorted OrderYou can store the values of a dimension in sorted order by taking the following actions: Limit the … commands sort the values of city in alphabetical order and then store the values in that order. SORT city … sorted order. SHOW VALUES (city NOSTATUS) ATLANTA COLUMBUS CONCORD LINCOLN PEORIA SEATTLE

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05526 Error: messages out of orderCause: An error has occurred while either trying to interpret or process a client request. This error normally includes other related errors. Action: Review other errors and contact Oracle Support Services.

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 Ascending or Descending Orderorder. Example 6-7 creates a new Source named sortedTuples whose values are the same as the Source … named base in sorted ascending order. Example 6-8 ranks the values of the Source named base in … descending order. Example 6-7 Ranking Values in Ascending Order Source sortedTuples = base.sortAscending … (); Example

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

Translator Command Line and Options

Order of Precedence of Option SettingsSQLJ takes option settings in the following order. At each step, it overrides any previous settings … the command line, with options from a -props file inserted, in order from left to right. Any later

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

Supplier: Top Level Order Process Activities (Oracle Workflow Help)

Supplier: Top Level Order Process Activities… Supplier: Receive External Order (Node 1) This event activity receives the B2B Purchase Order event … message that is sent to the Supplier: Top Level Order process by the Event Manager when the event is … : Receive iStore Order (Node 2) This event activity receives a purchase order event message

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05531 Error: messages out of orderCause: An error has occurred while either trying to interpret or process a client request. This error normally includes other related errors. Action: Review other errors and contact Oracle Support Services.

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

Performance Tuning

How do I make a ORDER BY score query faster?CONTAINS (TEXT, 'searchterm', 1) > 0 ORDER BY SCORE(1) DESC; Note that for this to work efficiently, there

Utilities, 9i Release 2 (9.2.0.2)

Export

Effect of Character Set Sorting Order on ConversionsIf the export character set has a different sorting order than the import character set, then

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Customizing Locale Data

Changing the Sort Order for One Character with a DiacriticTo change the order of a specific character with a diacritic, insert the character directly into … you cannot cut and paste them into the new location. This example changes the sort order for ä so … 12-32 Changing the Sort Order of One Character with a Diacritic Text description of the illustration … value of ä. The code point

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

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

Summary of the Supplier: Get Order Details SubprocessTo view the properties of the Supplier: Get Order Details subprocess, select its process activity … higher level process. When you display the Process window for the Supplier: Get Order Details … item from the purchase order. When both the item number and item description have been retrieved

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

Managing Tables

Using the ORDER BY Clause with Index-Organized TablesIf an ORDER BY clause only references the primary key column or a prefix of it, then the optimizer … * FROM admin_docindex2 ORDER BY token, doc_id; SELECT * FROM admin_docindex2 ORDER BY token; If, however … , you have an ORDER BY clause on a suffix of the primary key column or non-primary key columns … admin_docindex2

Setup and Configuration, 9i Release 2 (9.2.0.2)

Configuring the Server Parameter File in Real Application Clusters Environments

Parameter File Search Order in Real Application ClustersOracle searches for your parameter file in a particular order depending on your platform. On UNIX … platforms, Oracle examines directories in the following order: $ORACLE_HOME/dbs/spfile sid.ora … $ORACLE_HOME/dbs/spfile.ora $ORACLE_HOME/dbs/init sid.ora The search order on Windows NT and Windows

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

Using Oracle TopSessions

Sorting the Order of Entries in the ChartBy default, the value of the sort statistic determines the order of session entries in the Oracle … TopSessions chart. However, you can use any field in the list to sort the order of displayed session entries by clicking on any column header in the list.

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

Optimizing SQL Statements

Controlling the Access Path and Join Order with HintsOptimizer" and Chapter 5, "Optimizer Hints" Join order can have a significant effect on performance. The … driving table if you could instead use another index that fetches 100 rows. Choose the join order so as to … join fewer rows to tables later in the join order. The following example shows how to tune join … order

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

Performance Tuning

Improved Response Time with FIRST_ROWS(n) for ORDER BY QueriesThe FIRST_ROWS(n) hint is new for release 9.0. When you need the first rows of an ORDER BY query … articles_tab where contains(article, 'Oracle')>0 order by pub_date desc; begin for i in c loop insert … statement that returns the rowids that contain the word test in sorted order. The code loops through the … FIRST_ROWS hint, Oracle

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

SQL for Aggregation in Data Warehouses

ORDER BY Clause Used with GROUP BY ExtensionsIn many cases, a query needs to order the rows in a certain way, and this is done with the ORDER BY … clause. The ORDER BY clause of a SELECT statement is unaffected by the use of GROUP BY, since the … ORDER BY clause is applied after the GROUP BY calculations are complete. Note that the ORDER BY

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

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

Summary of the Supplier: Top Level Order ProcessTo view the properties of the Supplier: Top Level Order process, select the process in the … Supplier: Top Level Order process, you see that the process consists of ten unique activities. To … below. The numbers themselves are not part of the process diagram. The Supplier: Top Level Order … workflow begins when the Supplier system

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

Making Queries Using Source Methods, 3 of 8

Effect of Input-Output Order on Source StructureThe structure of a Source is determined by the order in which you turn the inputs of the Source … no outputs.The timesDim and productsDim Source objects do not have any inputs or outputs. The order

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

Using Oracle TopSessions

Sorting the Order of Entries in the ChartBy default, the value of the sort statistic determines the order of session entries in the Oracle … TopSessions chart. However, you can use any field in the list to sort the order of displayed session entries by clicking on any column header in the list.

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

B2B Purchase Order Event (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)

Supplier: Get Order Details Subprocess Activities (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)

B2B Purchase Order Acknowledgement Event (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)

Supplier: Top Level Order Process Activities (Oracle Workflow Help)

Oracle Workflow Guide Release 2.6.2                              Contents   Index   Glossary Master Index Feedback

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

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

Performance Tuning

Improved Response Time with Local Partitioned Index for Order by Scorewhen you order by score. This is because all hits to the query across all partitions must be … local partitioned index under the following conditions: The text query itself including the order by … contains(doc, 'oracle', 1)>0 order by score(1) desc; and you are only interested in fetching top 20 rows … where contains(doc, 'oracle',

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 … the Non-Spacing Characters screen. Figure 12-30 Changing the Sort Order for All Characters with the … Secondary in the Paste Node

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

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

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

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: Get Order Details Subprocess (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: Top Level Order Process (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)

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.

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

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.