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


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


Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

Manually Recompiling Invalid Objects with PL/SQL Package Proceduresindividual 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

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

Using a PL/SQL Package to Display Information About Schema ObjectsThe 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:

Database Security Guide, 11g Release 2 (11.2)

What's New in Oracle Database Security?

Enhancements for the UTL_SMTP PL/SQL PackageStarting 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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Packages

Package Statespecification 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.

SQL Developer User's Guide, 11g Release 2 (11.2)

Dialog Boxes for Creating/Editing Objects

Create PL/SQL PackageUse 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

Database Security Guide, 11g Release 2 (11.2)

What's New in Oracle Database Security?

New DBMS_SCHEDULER PL/SQL Package Global Scheduler AttributesThe DBMS_SCHEDULER PL/SQL package the following two new global scheduler attributes, which are used

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

Profiler API: Package DBMS_PROFILERThe 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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Optimization and Tuning

Trace API: Package DBMS_TRACEThe 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

XML DB Developer's Guide, 11g Release 2 (11.2)

PL/SQL Package DBMS_XMLSTORE

14 PL/SQL Package DBMS_XMLSTOREThis 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

OLAP DML Reference, 11g Release 2 (11.2)

OLAP_API_SESSION_INIT PL/SQL Package

C OLAP_API_SESSION_INIT PL/SQL PackageGo to main content 591/593 C OLAP_API_SESSION_INIT PL/SQL Package The OLAP_API_SESSION_INIT PL/SQLpackage provides procedures for maintaining a table of initialization parameters for the OLAP API … OLAP API The OLAP_API_SESSION_INIT package contains procedures for

OLAP DML Reference, 11g Release 2 (11.2)

  DBMS_AW PL/SQL Package

B   DBMS_AW PL/SQL PackageThe DBMS_AW PL/SQL package provides procedures and functions for interacting with analytic workspaces.

XML DB Developer's Guide, 11g Release 2 (11.2)

Generating XML Data from the Database

Using PL/SQL Package DBMS_XMLGENfrom 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

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Database PL/SQL Language Reference - Contents

ContentsValidation 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

OLAP DML Reference, 11g Release 2 (11.2)

  DBMS_AW PL/SQL Package

Aggregation Facilities within the WorkspaceBased 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

OLAP DML Reference, 11g Release 2 (11.2)

  DBMS_AW PL/SQL Package

Example: Evaluating Sparsity in the GLOBAL Schemaunits_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

OLAP DML Reference, 11g Release 2 (11.2)

  DBMS_AW PL/SQL Package

Example: Using the ADVISE_REL Proceduredescribed in Sample Dimension: Customer in the Global Analytic Workspace. The following PL/SQL

XML DB Developer's Guide, 11g Release 2 (11.2)

PL/SQL Package DBMS_XMLSTORE

Inserting with DBMS_XMLSTOREDBMS_XMLSTORE.closeContext(insCtx); END; / 2 rows inserted. PL/SQL procedure successfully completed

XML DB Developer's Guide, 11g Release 2 (11.2)

PL/SQL Package DBMS_XMLSTORE

Updating with DBMS_XMLSTORETo 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

XML DB Developer's Guide, 11g Release 2 (11.2)

PL/SQL Package DBMS_XMLSTORE

Overview of PL/SQL Package DBMS_XMLSTOREPL/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

OLAP DML Reference, 11g Release 2 (11.2)

  DBMS_AW PL/SQL Package

Using the Sparsity AdvisorTake 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