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
Fields of XMLPrintDriver of XMLPrintDriver → Implemented Interfaces of XMLPrintDriver PrintDriver Fields of XMLPrintDriver of XMLPrintDriver … Table 2-24 Fields of XMLPrintDriver Field Syntax Description out protected XMLOutputStream out XMLOutputStream object
Parameters → CREATE_MASTER_REPOBJECT Procedure Parameters Parameters Description sname Name of the schema in which the object that you … want to replicate is located. oname Name of the object you are replicating. If ddl_text is NULL … be a maximum of 27 bytes long, and package names should be no more than 24 bytes. The object cannot … be a
Exceptions → master site that you are attempting to add is already part of the master group. nonmasterdef Invocation
Parameters → Table 53-139 WAIT_MASTER_LOG Procedure Parameters Parameter Description gname Name of the master … group. record_count Procedure returns whenever the number of incomplete activities is at or below this … threshold. timeout Maximum number of seconds to wait before the procedure returns. true_count (out parameter) Returns the number of
Syntax → to accept items of type VARCHAR2, NCHAR, NUMBER, or DATE. There are two additional procedures to pack RAW and ROWID items.
Pragmas → pragma restrict_references(next_item_type,WNDS,RNDS);
Parameter → Table 4-18 START_APPLY Procedure Parameter Parameter Description apply_name The apply process name. A NULL setting is not allowed.
REVOKE_SYSTEM_PRIVILEGE Procedure → This procedure performs a revoke of a system privilege from a user or role.
GRANT_SWITCH_CONSUMER_GROUP Procedure → This procedure grants the privilege to switch to a resource consumer group.
Package Overview → A package is an encapsulated collection of related program objects stored together in the database … creating multiple procedures with the same name in the same package, each taking arguments of different
Syntax → PROCEDURE parseBuffer( p Parser, doc VARCHAR2); Parameter IN / OUT Description p (IN) Parser instance. doc (IN) XML document buffer to parse.
Assigning a SQL Query Result to a PL/SQL Variable → You can use the SELECT statement to have Oracle assign values to a variable. For each item in the select list, there must be a corresponding, type-compatible variable in the INTO list. An example follows: DECLARE emp_id emp.empno%TYPE; emp_name emp.ename%TYPE; wages NUMBER(7,2); BEGIN -- assign a value to emp_id here SELECT ename, sal + comm INTO emp_name, wages FROM emp WHERE empno = emp_id;... END;
PL/SQL Expressions and Comparisons → , literal, or function call that contributes a value to an expression. An example of a simple arithmetic … ternary operators. The simplest expressions consist of a single variable, which yields a value directly … . PL/SQL evaluates (finds the current value of) an expression by combining the values of the … (priority).
PL/SQL Architecture → The PL/SQL compilation and run-time system is a technology, not an independent product. Think of … . Figure 1-4 PL/SQL Engine Text description of the illustration pls81004_plsql_engine.gif
CASE Expressions → more WHEN clauses, which are checked sequentially. The value of the selector determines which … clause is executed. The first WHEN clause that matches the value of the selector determines the result … ; The optional ELSE clause works similarly to the ELSE clause in an IF statement. If the value of … the selector is not one of
Summary of DBMS_ORACLE_TRACE_AGENT Subprograms → This package contains only one subprogram: SET_ORACLE_TRACE_IN_SESSION.
Description of DBMS_XSLPROCESSOR → template is instantiated to create part of the result tree. This PL/SQL implementation of the XSL … processor followed the W3C XSLT working draft (rev WD-xslt-19990813) and included the required behavior of … an XSL processor in terms of how it must read XSLT stylesheets and the transformation it must effect
Syntax → DBMS_REPCAT.CANCEL_STATISTICS ( sname IN VARCHAR2, oname IN VARCHAR2);
COMMENT_ON_MVIEW_REPSITES Procedure → This procedure updates the SCHEMA_COMMENT field in the DBA_REPGROUP data dictionary view for the specified materialized view group. The group name must be registered locally as a replicated materialized view group. This procedure must be executed at the materialized view site.