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...THEN...ELSE → The 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
boolean-expression → Any 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
Using the IF-THEN Statement → the 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;
Using the IF-THEN-ELSE Statement → statements: 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:
Using the IF-THEN-ELSIF Statement → ELSEIF 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
Starting the Database Upgrade Assistant → to 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
Managing Access to Schema Objects → the 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
Viewing Tables → schemas, 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.
Recording Your DBID and DB_UNIQUE_NAME → , select the Administration page, then under Storage, click Controlfiles, then select the Advanced
Oracle Database Version Restrictions → upgrade first to the closest release as listed. You can then upgrade the database to the current release.
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 … 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
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
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
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
Using the SQL Tuning Advisor → following: 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
Dropping Indexes → the constraint and then, if the index is not dropped as a result of that action, drop the index.
Backing Up Your Database → types of Oracle database backup, then explains how to perform the different backup types, how to take
Creating a New Role → can then grant the role to other roles or users. A user can require several different roles, each
Deleting Obsolete Backups → as specified by the backup retention policy, and then only delete them when space is needed.
Overview of the Database Upgrade Assistant → redo 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