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
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
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 → , 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
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
Using the Scheduler in Real Application Clusters Environments → architecture, with the job coordinator for each instance exchanging information with the others.
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
Unhandled Exceptions → : Avoid unhandled exceptions by including an OTHERS exception handler at the top level of every PL/SQL program.
DATABASE Triggers → OTHERS THEN RAISE_APPLICATION_ERROR (-20000, 'Unexpected error: '|| DBMS_Utility.Format_Error_Stack); END; /
Delimiters → embed any others characters (including whitespace characters) inside a delimiter. Table 2-2
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;
Exception Categories → OTHERS exception handler. A specific exception handler is more efficient than an OTHERS exception
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
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
Migrating the Database to Oracle ASM Using RMAN → ; DBMS_OUTPUT.PUT_LINE(stmt); EXECUTE IMMEDIATE stmt; EXCEPTION WHEN OTHERS THEN EXECUTE IMMEDIATE
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.
Using Multiple Tablespaces → while others remain online, providing better overall availability. Optimizing tablespace use by
Internally Defined Exceptions → … Otherwise, you can handle them only with OTHERS exception handlers. To give a name to an internally
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
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