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
IF Statement → The 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
IF...THEN...ELSE → The 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
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 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
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
BFILE check if open → The 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"
BFILE check if exists → The session waits to check if an external large object (LOB) exists. Wait Time: The total elapsed
Using the IF-THEN Statement → The 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
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
Dropping Indexes → whether 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.
Dropping a Table → If 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
Shutting Down and Restarting the Instance and Database → If you need to shut down and later restart your instance or database, you can do this with the
Defining Blackout Time Periods → planned 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.
Upgrading the Database Using the Database Upgrade Assistant → specified 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
Starting the Database Upgrade Assistant → During 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
Managing Memory Parameters → … If 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
Checking Prerequisites → … If 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.
Using Oracle Recommendations for Managing Undo → summarized. To update the analysis, click Update Analysis. If Oracle recommends that you extend the undo
Starting DBCA → During 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
Credentials for Performing Oracle Enterprise Manager Backup and Recovery → scheduled 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
Using the Undo Advisor → extend 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