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 9805 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

THEN *TO * TRIGGER

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

PL/SQL Control Structures

IF-THEN-ELSIF Statement: IF condition1 THEN sequence_of_statements1 ELSIF condition2 THEN sequence_of_statements2 ELSE … sales > 50000 THEN bonus:= 1500; ELSIF sales > 35000 THEN bonus:= 500; ELSE bonus:= 100; END IF

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

PL/SQL Control Structures

IF-THEN Statementthe keywords THEN and END IF (not ENDIF ), as follows: IF condition THEN sequence_of_statements END … example follows: IF sales > quota THEN compute_bonus(empid); UPDATE payroll SET pay = pay + bonus WHERE … empno = emp_id; END IF; You might want to place brief IF statements on a single line, as in IF x > y THEN high:=

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

PL/SQL Control Structures

IF-THEN-ELSE Statementstatements, as follows: IF condition THEN sequence_of_statements1 ELSE sequence_of_statements2 END IF; The … executed when the condition is false or : IF trans_type = 'CR' THEN UPDATE accounts SET balance … THEN and ELSE clauses can include IF statements. That is, IF statements can be nested, as the … following example shows:

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

Failover in Cluster Configurations

Step 3: Stop, then Restart, the Directory Server and OID MonitorMonitor, then restart them by using either of the optional flags -host or -h. Do this before any

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

Configuring CyberSafe Authentication

If everything seems to work fine, but then you issue another query and it fails:Check that the initial ticket is forwardable. You must have obtained the initial ticket by running kinit -f. Check the expiration date on the credentials. If the credentials have expired, close the connection and run kinit to get a new initial ticket. Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. Home Book List Contents Index Master Index Feedback

Advanced Replication, 9i Release 2 (9.2.0.2)

Replication Management Tool Introduction

Note: Oracle Enterprise Edition is required for multimaster replication. If your installation is Oracle…for multimaster replication, then you use the Multimaster Replication object to set up your master … required for multimaster replication. If your installation is Oracle Standard Edition, then you can have

Replication Management API Reference, 9i Release 2 (9.2.0.2)

Managing a Master Replication Environment

Note: If progress appears to stop during one of the procedures described in the following sections,…/import and there are integrity constraints that span more than one master group, then you must … data dictionary view at the master definition site, then the process is started and is not yet … data dictionary view, then the process is started and is not yet complete for that master group … the master definition site for mgroup1

Replication Management API Reference, 9i Release 2 (9.2.0.2)

Managing a Master Replication Environment

Note: If you are viewing this document online, then you can copy the text from the "BEGINNING OF SCRIPT"…… Note: If you are viewing this document online, then you can copy the text from the "BEGINNING OF SCRIPT … " line on this page to the "END OF SCRIPT" line into a text editor and then edit the text to create … queue, then you need to resolve the error situation and then manually reexecute the deferred

Replication Management API Reference, 9i Release 2 (9.2.0.2)

Managing a Master Replication Environment

Note: If you are viewing this document online, then you can copy the text from the "BEGINNING OF SCRIPT"…/import to add sites to a master group. Note: If you are viewing this document online, then you can copy … editor and then edit the text to create a script for your environment … exist at the new master sites, then create them now. In this example, the replicated schema is hr … any of the tables in the master group have circular

Replication Management API Reference, 9i Release 2 (9.2.0.2)

Managing a Master Replication Environment

Note: If you are viewing this document online, then you can copy the text from the "BEGINNING OF SCRIPT"…: If you are viewing this document online, then you can copy the text from the "BEGINNING OF SCRIPT … " line on this page to the "END OF SCRIPT" line into a text editor and then edit the text to create a … ****************************** Step 1 If you are using full database export/import, then create the databases that you want

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Management Server Messages (Client Tier)

VTK-1002: The Oracle Management Server you are trying to connect to is still in the process of initialization.…: Wait for the Oracle Management Server to start up completely and then try logging in again.

Advanced Replication, 9i Release 2 (9.2.0.2)

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,

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

Object Cache Navigation

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

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

Jobs

Parameters: SQL Parameters. Enter one or more arguments that you want the script to use. Override Preferred…Script Text. You can copy and paste your script into the Script Text box. Hint: If you need to determine whether a SQL error has occurred during the running of a SQL script, include "WHENEVER SQLERROR EXIT SQL.SQLCODE" at the beginning of the script. If a SQL error occurs, the job status is set to failed. Run DBA Script This job executes a Server Manager line mode script that contains DBA commands.

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

Jobs

Parameters: Override Preferred Credentials. You can use the preferred credentials that have been set…Script Text. You can copy and paste your script into Script Text box. Shutdown Database This job task shuts down an Oracle database instance.

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

OCI Relational Functions, 16 of 38

mode IN The modes supported are OCI_DEFAULT - for a new session pool creation. OCI_SPC_REINITIALIZE…OCI_SPC_HOMOGENEOUS - all sessions in the pool will be authenticated with the username and password passed to OCISessionPoolCreate(). The authentication handle (parameter authInfo ) passed into OCISessionGet() is ignored in this case. Moreover, the sessMin and the SessIncr values are considered only in this case. No proxy session can be created in this mode.

Advanced Replication, 9i Release 2 (9.2.0.2)

Deployment Templates Concepts and Architecture

In some situations, you may benefit from using row subsetting with an assignment table. An assignment…… For example, if a new product is added to a particular warehouse, then the manager would simply add

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00000 to ORA-00899

ORA-00705 inconsistent state during start up; shut down the instance, then restart itCause: A previous attempt to start an instance was terminated. Action: Shut down the instance completely and then restart it.