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

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

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

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 Concepts, 11g Release 2 (11.2)

Glossary

PL/SQL packageA logical grouping of related PL/SQL types, variables, and subprograms.

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

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 Packages

How STANDARD Package Defines the PL/SQL EnvironmentA package named STANDARD defines the PL/SQL environment. The package specification declares public … types, variables, exceptions, subprograms, which are available automatically to PL/SQL programs. For … full name: abs_diff:= STANDARD.ABS(x - y); Most SQL functions are

Database Concepts, 11g Release 2 (11.2)

Server-Side Programming: PL/SQL and Java

8 Server-Side Programming: PL/SQL and JavaEXECUTE command PL/SQL Packages A PL/SQL package is a group of related subprograms, along with the cursors … UTL_HTTP package enables HTTP callouts from PL/SQL and SQL to access data on the Internet or to … the package

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)

PL/SQL Dynamic SQL

7 PL/SQL Dynamic SQLvariables. PL/SQL provides two ways to write dynamic SQL: Native dynamic SQL, a PL/SQL language … (that is, native) feature for building and running dynamic SQL statements DBMS_SQL package, an API for … you need both the DBMS_SQL package

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

PL/SQL Static SQL

6 PL/SQL Static SQLStatic SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement. This chapter … describes static SQL and explains how to use it. Topics Description of Static SQL Cursors Query … Transactions See Also: \"Resolution of Names in Static

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

PL/SQL Triggers

9 PL/SQL TriggersA trigger is like a stored procedure that Oracle Database invokes automatically whenever a specified event occurs. Note: The database can detect only system-defined events. You cannot define your own events. Topics Overview of Triggers Reasons to Use Triggers DML Triggers System Triggers Subprograms Invoked by Triggers Trigger Compilation, Invalidation, and Recompilation Exception Handling in Triggers

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

Overview of PL/SQL

PL/SQL EngineThe PL/SQL compilation and runtime system is an engine that compiles and runs PL/SQL units. The … either environment, the PL/SQL engine accepts as input any valid PL/SQL unit. The engine runs … procedural statements, but sends SQL statements