How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Efficient Use of Integrity Constraints: A Procedure → Using 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
Object Values → Object 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
INDEX_SS_ASC Hint → scans 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
Table 7-10 BETWEEN Conditions → expr1 AND expr1 less than or equal to expr3 ) SELECT * FROM employees WHERE salary BETWEEN 2000 AND 3000 ORDER BY employee_id;
COLLECT → is 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
INDEX_ASC Hint → entries 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
INDEX_SS_DESC Hint → ascending, 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.
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
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.
Detecting Suspended Statements → When a resumable statement is suspended, the error is not raised to the client. In order for
Table 7-2 Comparison Conditions → ORDER 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
FIRST_VALUE → salary. 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
LAST_VALUE → highest 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
CUME_DIST → by 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
ORDERED Hint → in 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
Stage 1: Client Application Issues DML Statements → At 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
CEIL → greater than or equal to the order total of a specified order: SELECT order_total, CEIL(order_total
10 SQL Statements: ALTER CLUSTER to ALTER JAVA → various 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
INDEX_SS Hint → 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\". For
EXISTS Condition → departments d WHERE EXISTS (SELECT * FROM employees e WHERE d.department_id = e.department_id) ORDER BY department_id;
Altering Database Availability → You can alter the availability of a database. You may want to do this in order to restrict access
NO_USE_MERGE Hint → example: SELECT /*+ NO_USE_MERGE(e d) */ * FROM employees e, departments d WHERE e.department_id = d.department_id ORDER BY d.department_id;
Managing Index-Organized Tables → ORDER BY Clause with Index-Organized Tables Converting Index-Organized Tables to Regular Tables
ROWIDTOCHAR → %' ORDER BY ROWID; ROWID ------------------ AAAFfIAAFAAAABSAAb
Checking the Status of Pending Transactions at sales → ADVICE TRAN_COMMENT Sales/New Order/Trans_type 10B FAIL_TIME 31-MAY-91 FORCE_TIME RETRY_TIME 31-MAY
Table 7-7 OR Truth Table → than $20,000: SELECT employee_id FROM employees WHERE commission_pct =.4 OR salary > 20000 ORDER BY employee_id;
ROWIDTONCHAR → : SELECT LENGTHB( ROWIDTONCHAR(ROWID) ) Length, ROWIDTONCHAR(ROWID) FROM employees ORDER BY length
ROWNUM Pseudocolumn → pseudocolumn 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
Table 4-2 Arithmetic Operators → operators. 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
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
Operator Precedence → Precedence is the order in which Oracle Database evaluates different operators in the same
CARDINALITY → , CARDINALITY(ad_textdocs_ntab) Cardinality FROM print_media ORDER BY product_id, cardinality
Ordering of Triggers → A 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
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.
Condition Precedence → Precedence is the order in which Oracle Database evaluates different conditions in the same
Step 2: Query DBA_2PC_PENDING → Sales/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#
Using the INCLUDING Clause → to 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
Table 2-5 Matrix of Datetime Arithmetic → + INTERVAL '30' DAY FROM orders ORDER BY order_id, \"Due Date\";
Creating a Sorted Hash Cluster → specified 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