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
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.
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
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
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:
PL/SQL package → A logical grouping of related PL/SQL types, variables, and subprograms.
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
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
How STANDARD Package Defines the PL/SQL Environment → A 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
8 Server-Side Programming: PL/SQL and Java → EXECUTE 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
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
7 PL/SQL Dynamic SQL → variables. 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
6 PL/SQL Static SQL → Static 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
9 PL/SQL Triggers → A 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
PL/SQL Engine → The 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