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


41 to 80 of 3637 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 1 (11.1)

Managing Integrity Constraints

Efficient Use of Integrity Constraints: A ProcedureUsing integrity constraint states in the following order can ensure the best benefits: Disable … benefits of using constraints in this order are: No locks are held. All constraints can go to enable state

Database SQL Language Reference, 11g Release 1 (11.1)

Datatype Comparison Rules

Object ValuesObject values are compared using one of two comparison functions: MAP and ORDER. Both functions … TYPE for a description of MAP and ORDER methods and the values they return

Database SQL Language Reference, 11g Release 1 (11.1)

Comments

INDEX_SS_ASC Hintscans the index entries in ascending order of their indexed values. In a partitioned index, the results … are in ascending order within each partition. Each parameter serves the same purpose as in \"INDEX … Hint\". The default behavior for a range scan is to scan index entries in ascending order of their … indexed values, or in

Database SQL Language Reference, 11g Release 1 (11.1)

BETWEEN Conditions

Table 7-10 BETWEEN Conditionsexpr1 AND expr1 less than or equal to expr3 ) SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000 ORDER BY employee_id;

Database SQL Language Reference, 11g Release 1 (11.1)

COLLECT

COLLECTis of a user-defined type, then column must have a MAP or ORDER method defined on it in order for … you to use the optional DISTINCT, UNIQUE and ORDER BY clauses. See Also: CAST Examples The following … oe.customers: CREATE TYPE phone_book_t AS TABLE OF phone_list_typ; / SELECT CAST(COLLECT(phone_numbers) AS phone_book_t) Phone_Book

Database SQL Language Reference, 11g Release 1 (11.1)

Comments

INDEX_ASC Hintentries in ascending order of their indexed values. Each parameter serves the same purpose as in … \"INDEX Hint\". The default behavior for a range scan is to scan index entries in ascending order of their … indexed values, or in descending order for a descending index. This hint does not change the … default order

Database SQL Language Reference, 11g Release 1 (11.1)

Comments

INDEX_SS_DESC Hintascending, then Oracle scans the index entries in descending order of their indexed values. In a … partitioned index, the results are in descending order within each partition. For a descending index, this … hint effectively cancels out the descending order, resulting in a scan of the index entries in … ascending order.

Database SQL Language Reference, 11g Release 1 (11.1)

Logical Conditions

Table 7-4 Logical Conditions(job_id IS NULL) ORDER BY employee_id; SELECT * FROM employees WHERE NOT (salary BETWEEN 1000 AND 2000 … ) ORDER BY employee_id; AND Returns TRUE if both component conditions are TRUE. Returns FALSE if … department_id = 30 ORDER BY employee_id; OR Returns TRUE if either component condition is TRUE. Returns … ' OR department_id

Database SQL Language Reference, 11g Release 1 (11.1)

Comments

INDEX_DESC Hint, then Oracle scans the index entries in descending order of their indexed values. In a partitioned … index, the results are in descending order within each partition. For a descending index, this hint … effectively cancels out the descending order, resulting in a scan of the index entries in ascending … order.

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Resumable Space Allocation

Detecting Suspended StatementsWhen a resumable statement is suspended, the error is not raised to the client. In order for

Database SQL Language Reference, 11g Release 1 (11.1)

Comparison Conditions

Table 7-2 Comparison ConditionsORDER BY employee_id; != ^= ÿ= Inequality test. Some forms of the inequality condition may be … unavailable on some platforms. SELECT * FROM employees WHERE salary != 2500 ORDER BY employee_id; > Greater … -than and less-than tests. SELECT * FROM employees WHERE salary > 2500 ORDER BY employee_id; SELECT … * FROM employees WHERE

Database SQL Language Reference, 11g Release 1 (11.1)

FIRST_VALUE

FIRST_VALUEsalary. SELECT department_id, last_name, salary, FIRST_VALUE(last_name) OVER (ORDER BY salary ASC ROWS … UNBOUNDED PRECEDING) AS lowest_sal FROM (SELECT * FROM employees WHERE department_id = 90 ORDER BY … employee_id) ORDER BY department_id, last_name, salary, lowest_sal; DEPARTMENT_ID LAST_NAME SALARY … . However, if the rows

Database SQL Language Reference, 11g Release 1 (11.1)

LAST_VALUE

LAST_VALUEhighest salary: SELECT last_name, salary, hire_date, LAST_VALUE(hire_date) OVER (ORDER BY salary ROWS … department_id = 90 ORDER BY hire_date) ORDER BY last_name, salary, hire_date, lv; LAST_NAME SALARY … the rows are ordered by hire_date in descending order, as in the next example, then the function … returns

Database SQL Language Reference, 11g Release 1 (11.1)

CUME_DIST

CUME_DISTby CUME_DIST is >0 to SELECT CUME_DIST(15500,.05) WITHIN GROUP (ORDER BY salary, commission_pct … , salary, CUME_DIST() OVER (PARTITION BY job_id ORDER BY salary) AS cume_dist FROM employees WHERE … job_id LIKE 'PU%' ORDER BY job_id, last_name, salary, cume_dist; JOB_ID LAST_NAME SALARY CUME_DIST

Database SQL Language Reference, 11g Release 1 (11.1)

Comments

ORDERED Hintin the order in which they appear in the FROM clause. Oracle recommends that you use the LEADING hint … requiring a join, the optimizer chooses the order in which to join the tables. You might want to … use the ORDERED hint to specify a join order if you know something that the optimizer does not know

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Transaction Processing: Case Study

Stage 1: Client Application Issues DML StatementsAt the Sales department, a salesperson uses SQL*Plus to enter a sales order and then commit it. The … application issues a number of SQL statements to enter the order into the sales database and update … possibility of an order being placed and then inventory not being updated to reflect the order. In … following

Database SQL Language Reference, 11g Release 1 (11.1)

CEIL

CEILgreater than or equal to the order total of a specified order: SELECT order_total, CEIL(order_total

Database SQL Language Reference, 11g Release 1 (11.1)

SQL Statements: ALTER CLUSTER to ALTER JAVA

10 SQL Statements: ALTER CLUSTER to ALTER JAVAvarious types of SQL statements and then describes the first set (in alphabetical order) of SQL … statements. The remaining SQL statements appear in alphabetical order in Chapter 11 through Chapter 19

Database SQL Language Reference, 11g Release 1 (11.1)

Comments

INDEX_SS Hintentries in ascending order of their indexed values. In a partitioned index, the results are in ascending … order within each partition. Each parameter serves the same purpose as in \"INDEX Hint\". For

Database SQL Language Reference, 11g Release 1 (11.1)

EXISTS Condition

EXISTS Conditiondepartments d WHERE EXISTS (SELECT * FROM employees e WHERE d.department_id = e.department_id) ORDER BY department_id;

Database Administrator's Guide, 11g Release 1 (11.1)

Altering Database Availability

Altering Database AvailabilityYou can alter the availability of a database. You may want to do this in order to restrict access

Database SQL Language Reference, 11g Release 1 (11.1)

Comments

NO_USE_MERGE Hintexample: SELECT /*+ NO_USE_MERGE(e d) */ * FROM employees e, departments d WHERE e.department_id = d.department_id ORDER BY d.department_id;

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Index-Organized Tables

Managing Index-Organized TablesORDER BY Clause with Index-Organized Tables Converting Index-Organized Tables to Regular Tables

Database SQL Language Reference, 11g Release 1 (11.1)

ROWIDTOCHAR

ROWIDTOCHAR%' ORDER BY ROWID; ROWID ------------------ AAAFfIAAFAAAABSAAb

Database Administrator's Guide, 11g Release 1 (11.1)

Manually Committing an In-Doubt Transaction: Example

Checking the Status of Pending Transactions at salesADVICE TRAN_COMMENT Sales/New Order/Trans_type 10B FAIL_TIME 31-MAY-91 FORCE_TIME RETRY_TIME 31-MAY

Database SQL Language Reference, 11g Release 1 (11.1)

Logical Conditions

Table 7-7 OR Truth Tablethan $20,000: SELECT employee_id FROM employees WHERE commission_pct =.4 OR salary > 20000 ORDER BY employee_id;

Database SQL Language Reference, 11g Release 1 (11.1)

ROWIDTONCHAR

ROWIDTONCHAR: SELECT LENGTHB( ROWIDTONCHAR(ROWID) ) Length, ROWIDTONCHAR(ROWID) FROM employees ORDER BY length

Database SQL Language Reference, 11g Release 1 (11.1)

ROWNUM Pseudocolumn

ROWNUM Pseudocolumnpseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of … WHERE ROWNUM If an ORDER BY clause follows ROWNUM in the same query, then the rows will be reordered by … the ORDER BY clause. The results can vary depending on the way the rows are accessed. For example … , if the ORDER

Database SQL Language Reference, 11g Release 1 (11.1)

Arithmetic Operators

Table 4-2 Arithmetic Operatorsoperators. SELECT * FROM order_items WHERE quantity = -1 ORDER BY order_id, line_item_id, product_id … . SELECT hire_date FROM employees WHERE SYSDATE - hire_date > 365 ORDER BY hire_date; * / Multiply

Database SQL Language Reference, 11g Release 1 (11.1)

Lexical Conventions

Lexical Conventions) FROM employees WHERE department_id = 30 ORDER BY last_name; SELECT last_name, salary * 12 … , MONTHS_BETWEEN( hire_date, SYSDATE ) FROM employees ORDER BY last_name; Case is insignificant in reserved words

Database SQL Language Reference, 11g Release 1 (11.1)

About SQL Operators

Operator PrecedencePrecedence is the order in which Oracle Database evaluates different operators in the same

Database SQL Language Reference, 11g Release 1 (11.1)

CARDINALITY

CARDINALITY, CARDINALITY(ad_textdocs_ntab) Cardinality FROM print_media ORDER BY product_id, cardinality

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Ordering of TriggersA relational database does not guarantee the order of rows processed by a SQL statement. Therefore … , do not create triggers that depend on the order in which rows are processed. For example, do not … , and the order in which they execute is important, use the FOLLOWS clause. Without the FOLLOWS clause … , the database chooses

Database SQL Language Reference, 11g Release 1 (11.1)

Logical Conditions

Table 7-6 AND Truth Table: SELECT * FROM employees WHERE hire_date 2500 ORDER BY employee_id; Table 7-7 shows the results of applying OR to two expressions.

Database SQL Language Reference, 11g Release 1 (11.1)

About SQL Conditions

Condition PrecedencePrecedence is the order in which Oracle Database evaluates different conditions in the same

Database Administrator's Guide, 11g Release 1 (11.1)

Manually Committing an In-Doubt Transaction: Example

Step 2: Query DBA_2PC_PENDINGSales/New Order/Trans_type 10B FAIL_TIME 31-MAY-91 FORCE_TIME RETRY_TIME 31-MAY-91 OS_USER SWILLIAMS OS_TERMINAL TWA139: HOST system1 DB_USER SWILLIAMS COMMIT#

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Index-Organized Tables

Using the INCLUDING Clauseto the beginning of the table (in their key order) to provide efficient primary key-based access. As … ; The stored column order is: c b a d (instead of: a b c d ). The last primary key column is b, based … on the stored column order. The INCLUDING column can be the last primary key column ( b in this … example), or any nonkey

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Table 2-5 Matrix of Datetime Arithmetic+ INTERVAL '30' DAY FROM orders ORDER BY order_id, \"Due Date\";

Database Administrator's Guide, 11g Release 1 (11.1)

Creating Hash Clusters

Creating a Sorted Hash Clusterspecified set of columns in ascending order, which can improve response time during subsequent … stored as they are made and processed later in first-in, first-out order (FIFO) when bills are … call_detail_cluster ( telephone_number, call_timestamp, call_duration ); Given the sort order of the data, the

Database SQL Language Reference, 11g Release 1 (11.1)

Model Conditions

IS ANY Conditionthe illustration is_any_condition.gif The condition always returns a Boolean value of TRUE in order to … ) IGNORE NAV UNIQUE DIMENSION RULES UPSERT SEQUENTIAL ORDER ( s[ANY, 2000] = 0 ) ORDER BY country