You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for OF


1 to 20 of 46566 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

OF *OFFLINE

XML API Reference - XDK and Oracle XML DB, 9i Release 2 (9.2.0.2)

Document Object Model (DOM)

Fields of XMLPrintDriver of XMLPrintDriverImplemented Interfaces of XMLPrintDriver PrintDriver Fields of XMLPrintDriver of XMLPrintDriver … Table 2-24 Fields of XMLPrintDriver Field Syntax Description out protected XMLOutputStream out XMLOutputStream object

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT, 2 of 2

ParametersCREATE_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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT, 2 of 2

Exceptionsmaster site that you are attempting to add is already part of the master group. nonmasterdef Invocation

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT, 2 of 2

ParametersTable 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_PIPE, 2 of 2

Syntaxto accept items of type VARCHAR2, NCHAR, NUMBER, or DATE. There are two additional procedures to pack RAW and ROWID items.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_PIPE, 2 of 2

Pragmaspragma restrict_references(next_item_type,WNDS,RNDS);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_APPLY_ADM, 2 of 2

ParameterTable 4-18 START_APPLY Procedure Parameter Parameter Description apply_name The apply process name. A NULL setting is not allowed.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_RESOURCE_MANAGER_PRIVS, 2 of 2

REVOKE_SYSTEM_PRIVILEGE ProcedureThis procedure performs a revoke of a system privilege from a user or role.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_RESOURCE_MANAGER_PRIVS, 2 of 2

GRANT_SWITCH_CONSUMER_GROUP ProcedureThis procedure grants the privilege to switch to a resource consumer group.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

Introduction, 1 of 2

Package OverviewA 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_XMLPARSER, 2 of 2

SyntaxPROCEDURE parseBuffer( p Parser, doc VARCHAR2); Parameter IN / OUT Description p (IN) Parser instance. doc (IN) XML document buffer to parse.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

Assigning a SQL Query Result to a PL/SQL VariableYou 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;

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

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).

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Overview of PL/SQL

PL/SQL ArchitectureThe 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

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Fundamentals of PL/SQL

CASE Expressionsmore 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_ORACLE_TRACE_AGENT, 2 of 2

Summary of DBMS_ORACLE_TRACE_AGENT SubprogramsThis package contains only one subprogram: SET_ORACLE_TRACE_IN_SESSION.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_XSLPROCESSOR, 1 of 2

Description of DBMS_XSLPROCESSORtemplate 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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT, 2 of 2

SyntaxDBMS_REPCAT.CANCEL_STATISTICS ( sname IN VARCHAR2, oname IN VARCHAR2);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT, 2 of 2

COMMENT_ON_MVIEW_REPSITES ProcedureThis 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.