Results for ORDER


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


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

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)

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

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

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.

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

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

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

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

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

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 … FIRST_ROWS hint, Oracle

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

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)

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

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

Oracle Workflow Guide Release 2.6.2                              Contents   Index   Glossary Master Index Feedback

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',





Was this page helpful?

Integrated Cloud Applications & Platform Services