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
Manually Recompiling Invalid Objects with PL/SQL Package Procedures → individual invalid objects using the package DBMS_UTILITY. The following PL/SQL block revalidates … ', namespace=>1); end; / The following PL/SQL block revalidates the package body HR.ACCT_MGMT: begin … . Examples Execute the following PL/SQL block to
Using a PL/SQL Package to Display Information About Schema Objects → The Oracle-supplied PL/SQL package procedure DBMS_METADATA.GET_DDL lets you obtain metadata (in the … form of DDL used to create the object) about a schema object. See Also: Oracle Database PL/SQL … Packages and Types Reference for a description of the DBMS_METADATA package Example:
Enhancements for the UTL_SMTP PL/SQL Package → Starting with this release, the UTL_SMTP PL/SQL package has the following new functionality: You … now can configure the UTL_SMTP PL/SQL package for use on both Transport Layer Security (TLS) and … password authentication schemes. See Oracle Database PL/SQL
Package State → specification or body) comprise its package state. If a PL/SQL package declares at least one variable … The values of the variables, constants, and cursors that a package declares (in either its … , constant, or cursor, then the package is stateful. otherwise, it is stateless.
Create PL/SQL Package → Use this dialog box to create a package to contain PL/SQL subprograms (functions or procedures, or … a combination). Schema: Database schema in which to create the PL/SQL package. Name: Name of the … the appearance of the code, because PL/SQL is not
New DBMS_SCHEDULER PL/SQL Package Global Scheduler Attributes → The DBMS_SCHEDULER PL/SQL package the following two new global scheduler attributes, which are used
Profiler API: Package DBMS_PROFILER → The Profiler API (\"Profiler\") is implemented as PL/SQL package DBMS_PROFILER, whose services … compute the time that your PL/SQL program spends at each line and in each subprogram and save these … you have CREATE privilege. You do not need the CREATE privilege to use the PL/SQL
Trace API: Package DBMS_TRACE → The Trace API (\"Trace\") is implemented as PL/SQL package DBMS_TRACE, whose services trace … : Package DBMS_PROFILER\" ). For detailed information about the DBMS_TRACE subprograms, see Oracle Database PL/SQL Packages and Types Reference. … manage. Start the tracing session. Run your
14 PL/SQL Package DBMS_XMLSTORE → This chapter introduces you to the PL/SQL package DBMS_XMLSTORE. This package is used to insert … topics: Overview of PL/SQL Package DBMS_XMLSTORE Using Package DBMS_XMLSTORE Inserting with
C OLAP_API_SESSION_INIT PL/SQL Package → Go to main content 591/593 C OLAP_API_SESSION_INIT PL/SQL Package The OLAP_API_SESSION_INIT PL/SQL … package provides procedures for maintaining a table of initialization parameters for the OLAP API … OLAP API The OLAP_API_SESSION_INIT package contains procedures for
B DBMS_AW PL/SQL Package → The DBMS_AW PL/SQL package provides procedures and functions for interacting with analytic workspaces.
Using PL/SQL Package DBMS_XMLGEN → from the package by supplying a SQL query and calling PL/SQL function newContext. Pass the context … . Get the XML result, using PL/SQL function getXML or getXMLType. By setting the maximum number of rows … to be retrieved for each fetch using PL/SQL
Contents → Validation Checks Explicit Format Models 8 PL/SQL Subprograms Reasons to Use Subprograms Nested, Package … Event Triggers Views for Information About Triggers 10 PL/SQL Packages What is a Package? Reasons to … Packages Package Writing Guidelines Package
Aggregation Facilities within the Workspace → Based on a percentage that you specify, ADVISE_REL suggests a set of dimension members to preaggregate. The ADVISE_CUBE procedure suggests a set of members for each dimension of a cube. Aggregation Facilities within the Workspace Instructions for storing aggregate data are specified in an analytic workspace object called an aggmap. The OLAP DML AGGREGATE command uses the aggmap to preaggregate the
Example: Evaluating Sparsity in the GLOBAL Schema → units_cube.cp COMPOSITE DEFINE units_cube NUMBER VARIABLE > PL/SQL procedure successfully completed … Example B-1, \"Sparsity Advisor Script for GLOBAL\" provides a SQL script for evaluating the … . Information Stored in AW_SPARSITY_ADVICE Table This SQL SELECT statement shows some columns from the
Example: Using the ADVISE_REL Procedure → described in Sample Dimension: Customer in the Global Analytic Workspace. The following PL/SQL
Inserting with DBMS_XMLSTORE → DBMS_XMLSTORE.closeContext(insCtx); END; / 2 rows inserted. PL/SQL procedure successfully completed
Updating with DBMS_XMLSTORE → To update (modify) existing data using package DBMS_XMLSTORE, you must specify which rows to update … . In SQL, you would do that using a WHERE clause in an UPDATE statement. With DBMS_XMLSTORE, you do
Overview of PL/SQL Package DBMS_XMLSTORE → PL/SQL package DBMS_XMLSTORE enables DML operations to be performed on relational tables using XML … and VARCHAR. PL/SQL functions insertXML, updateXML, and deleteXML, which are also present in package … . It takes a canonical XML mapping similar to that produced by package
Using the Sparsity Advisor → Take these steps to use the Sparsity Advisor: Call SPARSITY_ADVICE_TABLE to create a table for storing the evaluation of the Sparsity Advisor. Call ADD_DIMENSION_SOURCE for each dimension related by one or more columns to the fact table being evaluated. The information that you provide about these dimensions is stored in a DBMS_AW$_DIMENSION_SOURCES_T variable. Call ADVISE_SPARSITY to evaluate the