
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
Public Views for the Design Environment
Others → Table 2-190 ALL_IV_ACTIVITY_FOLDERS Column Name Data Type Description PROJECT_ID NUMBER(9) ID of the project PROJECT_NAME VARCHAR2(255) Name of the project ACTIVITY_FOLDER_ID NUMBER(9) ID of the activity folder ACTIVITY_FOLDER_NAME VARCHAR2(255) Name of the activity folder BUSINESS_NAME VARCHAR2(1000) Business name of the activity folder DESCRIPTION VARCHAR2(4000) Description of the activity folder
Administering Oracle ASM Disk Groups
Setting Disk Group Attributes for Oracle ASM File Access Control → the user that owns the file, users in the same user group, and others not in the user group. This … enables read-write access for the owner, read access for users in the group, and no access to others not
Exception Handler
Exception Handler → , then the associated statements run. OTHERS Specifies all exceptions not explicitly specified in the … statements run. Note: Oracle recommends that the last statement in the OTHERS exception handler be either … WHEN OTHERS exception handler is optional. It can appear only once, as the last exception handler
PL/SQL Static SQL
Query Result Set Processing With Explicit Cursors, OPEN, FETCH, and CLOSE → \".) This result set processing technique is more complicated than the others, but it is also more flexible
Oracle Scheduler Concepts
Using the Scheduler in Real Application Clusters Environments → architecture, with the job coordinator for each instance exchanging information with the others.
PL/SQL Error Handling
Guidelines for Avoiding and Handling Exceptions → named exceptions instead of using OTHERS exception handlers. Learn the names and causes of the … bad data. Avoid unhandled exceptions by including an OTHERS exception handler at the top level of … every PL/SQL program. Make the last statement in the OTHERS exception handler either RAISE or an
PL/SQL Error Handling
Unhandled Exceptions → : Avoid unhandled exceptions by including an OTHERS exception handler at the top level of every PL/SQL program.
PL/SQL Triggers
DATABASE Triggers → OTHERS THEN RAISE_APPLICATION_ERROR (-20000, 'Unexpected error: '|| DBMS_Utility.Format_Error_Stack); END; /
PL/SQL Language Fundamentals
Delimiters → embed any others characters (including whitespace characters) inside a delimiter. Table 2-2
PL/SQL Optimization and Tuning
NO_DATA_NEEDED Exception → You must understand the predefined exception NO_DATA_NEEDED in two cases: You include an OTHERS … an OTHERS exception handler to handle unexpected exceptions, then it must also include an exception … handler for the expected NO_DATA_NEEDED exception. Otherwise, the OTHERS exception handler handles … NO_DATA_NEEDED THEN RAISE;
PL/SQL Error Handling
Exception Categories → OTHERS exception handler. A specific exception handler is more efficient than an OTHERS exception
Logical Data Model Foundation
WEIGHTED FAIR QUEUING SERVICE Reference Defines a cross between priority queuing and fair queuing, seeking… → serviced so that none are starved, but some queues are serviced more than others. A portion of the
Managing Resources with Oracle Database Resource Manager
Granting and Revoking the Switch Privilege → ; / User SCOTT is also granted permission to grant switch privileges for OLTP to others. If you grant … also grant switch privileges for that consumer group to others. Revoking Switch Privileges The
Performing Oracle ASM Data Migration with RMAN
Migrating the Database to Oracle ASM Using RMAN → ; DBMS_OUTPUT.PUT_LINE(stmt); EXECUTE IMMEDIATE stmt; EXCEPTION WHEN OTHERS THEN EXECUTE IMMEDIATE
Managing Users and Securing the Database
Managing User Privileges and Roles → right to grant specific privileges to others. To learn how to administer privileges and roles for users, see Oracle Database Security Guide.
Managing Tablespaces
Using Multiple Tablespaces → while others remain online, providing better overall availability. Optimizing tablespace use by
PL/SQL Error Handling
Internally Defined Exceptions → … Otherwise, you can handle them only with OTHERS exception handlers. To give a name to an internally
PL/SQL Error Handling
Propagation of Exceptions Raised in Declarations → only with an OTHERS exception handler. In Example 11-13, the inner block declares an exception named … exception with an OTHERS exception handler. Example 11-13 Exception that Propagates Beyond Scope is
PL/SQL Triggers
Exception Handling in Triggers → OTHERS THEN INSERT INTO emp_log (Emp_id, Log_date, New_salary, Action) VALUES (99, SYSDATE, NULL, 'Could … ' ); EXCEPTION WHEN OTHERS THEN INSERT INTO emp_log (Emp_id, Log_date, New_salary, Action) VALUES (99
PL/SQL Error Handling
Error Code and Error Message Retrieval → (64); BEGIN SELECT last_name INTO name FROM EMPLOYEES WHERE EMPLOYEE_ID = -1; EXCEPTION WHEN OTHERS