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

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Starting the Database Upgrade Assistantto the new Oracle release, then the Database Upgrade Assistant is launched automatically at the end … of the software install. You can then continue as described in "Upgrading the Database Using the … that time, then you can do so later by launching the Database Upgrade Assistant. To launch the

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Managing Access to Schema Objectsthe access methods you want to allow in a role. The role can then be assigned to the users who … Object Type then click Add. Enter the schema name and object name, with a period separator, in the … to the Edit Role page then click Object Privileges. Then select, in turn, each privilege you want … to revoke and

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Viewing Tablesschemas, click the flashlight adjacent to the Schema box to select another schema, then click Go to … view a table definition, from the Results list, either click the link in the Table Name column or select a table, such as HR.EMPLOYEES, then click View.

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Recording Your DBID and DB_UNIQUE_NAME, select the Administration page, then under Storage, click Controlfiles, then select the Advanced

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Oracle Database Version Restrictionsupgrade first to the closest release as listed. You can then upgrade the database to the current release.

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Upgrading the Database Using the Database Upgrade Assistantspecified conditions. Then, click Next. If you need help at any page or want to consult more documentation … about the Database Upgrade Assistant, then click Help to open the online help. At the Select a … Database page, select the database you want to upgrade. Then, click Next. You may need to provide a user … Sysaux page, give

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

Control File, then your database becomes unavailable. But as long as you still have any of the control file copies … control files, then restart your database. Another option is to delete the failed control file from

2 Day DBA, 10g Release 1 (10.1)

10 Monitoring and Tuning the Database

Using the SQL Access Advisor… You then select if you want the advisor to recommend indexes, materialized views or both. You can … concentrating on highest cost statements. You then schedule and submit your job. Results are posted on the

2 Day DBA, 10g Release 1 (10.1)

10 Monitoring and Tuning the Database

Running ADDM Manually, then ADDM. The Create ADDM Task page appears. Figure 10-5 is a screen shot of Create ADDM Task page … snapshots, select a start time and click OK, then choose an end time and click OK. The ADDM Task page

2 Day DBA, 10g Release 1 (10.1)

10 Monitoring and Tuning the Database

Using the SQL Tuning Advisorfollowing: On the Home Page, under Related Links, click Advisor Central, then click SQL Tuning Advisor. The … . You then select one or more SQL statements to analyze during the selected period. Click Run SQL … status is COMPLETED. You can check the status by clicking your browser's Refresh button. Then, select

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Dropping Indexesthe constraint and then, if the index is not dropped as a result of that action, drop the index.

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Backing Up Your Databasetypes of Oracle database backup, then explains how to perform the different backup types, how to take

2 Day DBA, 10g Release 1 (10.1)

7 Administering Users and Security

Creating a New Rolecan then grant the role to other roles or users. A user can require several different roles, each

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Deleting Obsolete Backupsas specified by the backup retention policy, and then only delete them when space is needed.

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Overview of the Database Upgrade Assistantredo logs. You can then act on these recommendations. For example, the Database Upgrade Assistant … user accounts in the upgraded database. The Database Upgrade Assistant then proceeds to create new