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 IF


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


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

IF Statement

IF StatementThe IF statement executes or skips a sequence of statements, depending on the value of a Boolean … expression. For more information, see "Testing Conditions: IF and CASE Statements". Syntax Description … , greater-than, or less-than. The sequence following the THEN keyword is executed only if the expression … returns TRUE. ELSE

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 … is not met. You can use IF only within programs. You can also use IF as a conditional operator in an … expression. See "IF as a Conditional Operator". Syntax IF  boolean-expression    THEN  statement1

DML Reference, 10g Release 1 (10.1)

IF...THEN...ELSE

boolean-expressioncontinues with the statement after the whole IF...THEN... command in the program. Notes IF with DO … You can use the IF command for conditional execution of two or more statements by following the THEN … or ELSE (or both) keywords with a DO... DOEND sequence. See Example 14-13, "Using IF...THEN...ELSE … ". IF

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Note: As explained in "Configuring Your Database for Basic Backup and Recovery", you can only use online…set of objects to back up. Enter your host operating system credentials if required, and click … if your database is set up to run in ARCHIVELOG mode. Under the Advanced section, if this is an … and does not require media recovery if you restore from this backup.) For now, leave the option for … generated for

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

BFILE check if openThe session waits for an external large object (LOB) to open. Wait Time: The total elapsed time for the isopen call Parameter Description session# See "session#" waited See "waited"

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

BFILE check if existsThe session waits to check if an external large object (LOB) exists. Wait Time: The total elapsed

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

4 Using PL/SQL Control Structures

Using the IF-THEN StatementThe simplest form of IF statement associates a condition with a sequence of statements enclosed by … the keywords THEN and END IF (not ENDIF ): IF condition THEN sequence_of_statements END IF; The … sequence of statements is executed only if the condition is true. If the condition is

2 Day DBA, 10g Release 1 (10.1)

Send Us Your Comments

Send Us Your Comments… Do you need more information? If so, where? Are the examples correct? Do you need more examples? What … features did you like most about this manual? If you find any errors or have any other suggestions … , section, and page number (if available). You can send comments to us in the following ways: Electronic … , Mailstop

2 Day DBA, 10g Release 1 (10.1)

8 Managing Schema Objects

Dropping Indexeswhether to continue the operation. If you are certain you have identified the correct index, click … Yes. The Edit table page displays a confirmation message if the index is successfully deleted. Note … the 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)

8 Managing Schema Objects

Dropping a TableIf you no longer need a table or its contents, you can drop the table using Enterprise Manager. Be … difficult and time-consuming to retrieve the records, if they can be retrieved, after you execute the … continue the operation. If you are certain you have identified the correct table, click Yes. The Edit

2 Day DBA, 10g Release 1 (10.1)

5 Managing the Oracle Instance

Shutting Down and Restarting the Instance and DatabaseIf you need to shut down and later restart your instance or database, you can do this with the

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

Defining Blackout Time Periodsplanned blackout, or choose immediately if you are bringing the database down now. Also select the … Repeating, accept the default of Do Not Repeat. If you want to repeat the blackout periodically, you … what you have entered, and if satisfied, click Finish. If not, you can click Back to change a setting.

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 … name and password with SYSDBA privileges if you do not have operating system authentication. On the … are used. For example, if an invalid PL/SQL module is called, it will first be recompiled before it … to complete your

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Starting the Database Upgrade AssistantDuring installation, if you install software only and specify that you are upgrading your database … Database Upgrade Assistant". If you perform a software-only install and do not upgrade your database at

2 Day DBA, 10g Release 1 (10.1)

5 Managing the Oracle Instance

Managing Memory ParametersIf you enabled Automatic Shared Memory Configuration when you configured your database, Oracle … recommends that you enable memory auto tuning. If Automatic Shared Memory Management is disabled

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Checking PrerequisitesIf your machine does not meet any of the requirements, an error message is displayed. The … documentation if you experience problems and need more information about exact requirements.

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

Using Oracle Recommendations for Managing Undosummarized. To update the analysis, click Update Analysis. If Oracle recommends that you extend the undo

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Starting DBCADuring installation, you can create and configure a new database. If you have already done so, you … do not need to read this section and can skip to the next chapter. However, if you choose to install … software only and later create a database, or if you want to create additional databases using the

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

Credentials for Performing Oracle Enterprise Manager Backup and Recoveryscheduled through Enterprise Manager. If you log in to Enterprise Manager with SYSDB A privileges … Credential. If you check this box before performing your action, the credentials you provide are stored … perform operations requiring host credentials. (If the database is down, however, as is required for

2 Day DBA, 10g Release 1 (10.1)

6 Managing Database Storage Structures

Using the Undo Advisorextend the undo tablespace if it is under space pressure. However, when the auto-extend tablespace … the Best Possible Undo Retention under analysis on the Undo Advisor page. If this time period is … longer than your longest running query, your undo tablespace is adequately configured. What if the best … possible retention time