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 THEN


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


DML Reference, 10g Release 1 (10.1)

IF...THEN...ELSE

IF...THEN...ELSEThe IF...THEN...ELSE command executes one or more commands in a program when a specified condition … expression. See "IF as a Conditional Operator". Syntax IF  boolean-expression    THEN  statement1    [ELSE  statement2 ] Arguments

DML Reference, 10g Release 1 (10.1)

IF...THEN...ELSE

boolean-expressionAny valid Boolean expression that returns either TRUE or FALSE. THEN statement1 Oracle OLAP … line as THEN. ELSE statement2 Oracle OLAP executes the statement2 argument when the Boolean expression … continues with the statement after the whole IF...THEN... command in the program. Notes IF with DO … You can use the IF command for

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the IF-THEN Statementthe keywords THEN and END IF (not ENDIF ): IF condition THEN sequence_of_statements END IF; The … THEN compute_bonus(empid); UPDATE payroll SET pay = pay + bonus WHERE empno = emp_id; END IF; You can … place brief IF statements on a single line: IF x > y THEN high:= x; END IF;

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the IF-THEN-ELSE Statementstatements: IF condition THEN sequence_of_statements1 ELSE sequence_of_statements2 END IF; The statements … in the ELSE clause are executed only if the condition is false or . The IF-THEN-ELSE statement … executed when the condition is false or : IF trans_type = 'CR' THEN UPDATE accounts SET balance … statements can be nested:

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the IF-THEN-ELSIF StatementELSEIF or ELSE IF ) to introduce additional conditions: IF condition1 THEN sequence_of_statements1 ELSIF … condition2 THEN sequence_of_statements2 ELSE sequence_of_statements3 END IF; If the first condition … executed. Consider the following example: BEGIN IF sales > 50000 THEN bonus:= 1500; ELSIF sales > 35000 … THEN

Administrator's Guide, 10g Release 1 (10.1)

Setting Up Background Workflow Engines (Oracle Workflow Administrator's Guide)

by the Workflow Engine and run later by a background engine. The main Workflow Engine can then continuethe notification to the appropriate performer, and then sets the notification activity to a status of … timed out and calls the Workflow Engine. The Workflow Engine then resumes by trying to execute a

Developer's Guide, 10g Release 1 (10.1)

Summary of the Document Review Process (Oracle Workflow Developer's Guide)

To view the properties of the Document Review process, select the process in the navigator tree, thenchoose Properties from the Edit menu. The Document Review process has a result type of Approval, indicating that when the process completes, it has a result of Approve or Reject (the lookup codes in the Approval lookup type associated with the Standard item type). This process activity is also runnable, indicating that you can initiate it as a top level process to run. The Details property page of

Performance Tuning Guide, 10g Release 1 (10.1)

17 Optimizer Hints

By default, hints do not propagate inside a complex view. For example, if you specify a hint in a query…query or inside views. If there is such a hint in the top-level query, then that hint is used regardless … of any such hints inside the views. If there is no top-level optimizer mode hint, then mode hints … mode hints in the referenced views conflict, then all mode hints in the views are discarded and the … (that is, if it appears

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Dropping Table Partitions You cannot drop a partition of a hash-partitioned table. Instead,…drop_table_subpartition Use this clause to drop a list subpartition from a range-list composite-partitioned table. Oracle Database deletes any rows in the dropped subpartition. Oracle Database drops the corresponding subpartition of any local index. Other index subpartitions are not affected. Any global indexes are marked UNUSABLE unless you specify the update_global_index_clause or update_all_indexes_clause.

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Changing Table Parallelization If table contains any columns of LOB or user-defined…10.0, then the database silently moves the storage table to the new tablespace along with the table … the INCLUDING column as part of this ALTER TABLE statement, then the overflow data segment is … index-organized table, then the overflow data segment is also rebuilt. The index and data segments of

Oracle® Advanced Security Administrator's Guide, 10g Release 1 (10.1)

12 Enterprise User Security Configuration Tasks and Troubleshooting

To create an ldap.ora file for your Oracle home: In the Oracle Net Configuration Assistant welcome page,…qualified domain name for a database. For example, if you have a database named db1.us.oracle.com, then … exists, then Database Configuration Assistant uses it and updates the wallet password. Enables auto

SQL Reference, 10g Release 1 (10.1)

CREATE FUNCTION

Semantics OR REPLACE Specify OR REPLACE to re-create the function if it already exists. Use this clause…creating the function results in compilation errors, then Oracle Database returns an error. You can see the

Security Guide, 10g Release 1 (10.1)

10 Administe ring User Privileges, Roles, and Profiles

Note: If your SYSTEM tablespace is locally managed, then users must be assigned a specific default locally…create the user, or add or change quotas later. If a new quota is less than the old one, then the … your SYSTEM tablespace is locally managed, then users must be assigned a specific default (locally

Advanced Replication, 10g Release 1 (10.1)

6 Planning Your Replication Environment

Note: To fast refresh a materialized view, you must add join columns in subqueries to the materialized…to one, then you do not need to add the join column to the materialized view log. A collection … datatypes, then the attributes of column objects can be logged in the materialized view log. For example … the materialized view log, then your materialized view creation or refresh may fail. Note: To fast … subquery is many to one,

Database, 10g Release 1 (10.1)

Apache module mod_rewrite

Note : There is a special feature: When you prefix a substitution field with http:// thishost :thisport…you prefix a substitution field with http:// thishost [:thisport ] then mod_rewrite automatically … `` httpd -l '' output. If yes, this functionality is available to mod_rewrite. If not, then you first … following rule, etc. ). This has the following effect: if a rule matches, then processing continues as … usual, i.e., the flag

Replication Administrator's Guide, 10g Release 1 (10.1)

1 Understanding Streams Replication

Note: An apply process applies ALTER object_type object_name RENAME changes, such as ALTER TABLE jobs…process receives a DDL LCR that specifies an operation that cannot be applied, then the apply process … . Therefore, if you want DDL changes that rename objects to be applied, then use ALTER object_type … or rollback segments, then the tablespaces or rollback segments must have the same names and … rollback segments are not specified

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Moving Table Partitions If partition is a hash partition, then the only attribute you…-time physical attributes for the new partition. If the table contains LOB columns, then you can also … partition_name, then Oracle Database assigns a name of the form SYS_P n. If you add a range partition to a … composite-partitioned table and do not describe the subpartitions, then the database assigns subpartition … names as

Performance Tuning Guide, 10g Release 1 (10.1)

17 Optimizer Hints

The HASH hint explicitly chooses a hash scan to access the specified table. It applies only to tables…specify one or more indexes: If this hint specifies a single available index, then the optimizer performs … on the table. If this hint specifies a list of available indexes, then the optimizer considers the … cost of a scan on each index in the list and then performs the index scan with the lowest cost. The … index not listed

SQL Reference, 10g Release 1 (10.1)

ALTER TABLE

Restrictions on Dropping Constraints You cannot drop a primary key or unique key constraint that is…driver processes only those columns in the select list. If you specify PROJECT COLUMN ALL, then the … than the ALL setting. If a subsequent query selects all columns of the external table, then the settings behave identically.

Programmer's Guide, 10g Release 1 (10.1)

13 Object Advanced Topics in OCI

Optimistic Locking Option 1 The first optimistic locking option is for OCI applications that run transactions…The preceding mechanism effectively implements an optimistic locking model.