没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle Database PLSQL Packages and Types Reference 12c
Oracle Database PLSQL Packages and Types Reference 12c
5星 · 超过95%的资源 需积分: 32 9 下载量 122 浏览量
更新于2023-03-16
评论
收藏 28.07MB PDF 举报
Oracle Database PLSQL Packages and Types Reference 12c
资源详情
资源评论
资源推荐
Oracle® Database
PL/SQL Packages and Types Reference
12c Release 2 (12.2)
E49945-21
August 2017
Oracle Database PL/SQL Packages and Types Reference, 12c Release 2 (12.2)
E49945-21
Copyright © 1996, 2017, Oracle and/or its affiliates. All rights reserved.
Primary Author: Prashant Kannan
Contributing Authors: Louise Morin, Denis Raphaely, Lance Ashdown, Drue Baker, Donna Carver, Maitreyee
Chaliha, Beethoven Cheng, Rhonda Day, Steve Fogel, Bryn Llewellyn, Paul Lane, David McDermid, Tony
Morales, Anne Murphy, Chuck Murray, Sue Pelski, Kathy Rich, Antonio Romero, Vivian Schupmann, Cathy
Shea, Margaret Taft, Kathy Taylor, Randy Urbano, Pat Huey, Drew Adams, Sarika Surumpudi, Rodney
Ward, Rajesh Bhatiya, Roopesh Ashok Kumar
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify,
license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means.
Reverse engineering, disassembly, or decompilation of this software, unless required by law for
interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on
behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are
"commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-
specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the
programs, including any operating system, integrated software, any programs installed on the hardware,
and/or documentation, shall be subject to license terms and license restrictions applicable to the programs.
No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications.
It is not developed or intended for use in any inherently dangerous applications, including applications that
may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you
shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its
safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this
software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are
used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron,
the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro
Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise
set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be
responsible for any loss, costs, or damages incurred due to your access to or use of third-party content,
products, or services, except as set forth in an applicable agreement between you and Oracle.
Contents
Preface
Audience cxxxvii
Documentation Accessibility cxxxvii
Related Documents cxxxvii
Conventions cxxxviii
Changes in This Release for Oracle Database PL/SQL Packages
and Types Reference
Changes in Oracle Database 12c Release 2 (12.2) cxli
1
Introduction to Oracle Supplied PL/SQL Packages & Types
1.1 Package Overview 1-2
1.1.1 Package Components 1-2
1.1.2 Using Oracle Supplied Packages 1-2
1.1.3 Creating New Packages 1-2
1.1.3.1 Separating the Specification and Body 1-3
1.1.4 Referencing Package Contents 1-5
1.2 Summary of Oracle Supplied PL/SQL Packages and Types 1-5
2
Oracle Application Express Packages APEX_APPLICATION
Through APEX_ZIP
3
CTX_ADM
4
CTX_ANL
iii
5
CTX_CLS
6
CTX_DDL
7
CTX_DOC
8
CTX_ENTITY
9
CTX_OUTPUT
10
CTX_QUERY
11
CTX_REPORT
12
CTX_THES
13
CTX_ULEXER
14
DBMS_ADDM
14.1 DBMS_ADDM Security Model 14-1
14.2 Summary of DBMS_ADDM Subprograms 14-1
14.2.1 ANALYZE_DB Procedure 14-3
14.2.2 ANALYZE_INST Procedure 14-4
14.2.3 ANALYZE_PARTIAL Procedure 14-5
14.2.4 COMPARE_CAPTURE_REPLAY_REPORT Function 14-6
14.2.5 COMPARE_DATABASES Function 14-6
14.2.6 COMPARE_INSTANCES Function 14-7
14.2.7 COMPARE_REPLAY_REPLAY_REPORT Function 14-8
14.2.8 DELETE Procedure 14-9
14.2.9 DELETE_FINDING_DIRECTIVE Procedure 14-9
iv
14.2.10 DELETE_PARAMETER_DIRECTIVE Procedure 14-10
14.2.11 DELETE_SEGMENT_DIRECTIVE Procedure 14-10
14.2.12 DELETE_SQL_DIRECTIVE Procedure 14-11
14.2.13 GET_ASH_QUERY Function 14-11
14.2.14 GET_REPORT Function 14-12
14.2.15 INSERT_FINDING_DIRECTIVE Procedure 14-12
14.2.16 INSERT_PARAMETER_DIRECTIVE Procedure 14-13
14.2.17 INSERT_SEGMENT_DIRECTIVE Procedure 14-14
14.2.18 INSERT_SQL_DIRECTIVE Procedure 14-15
14.2.19 REAL_TIME_ADDM_REPORT Function 14-16
15
DBMS_ADVANCED_REWRITE
15.1 DBMS_ADVANCED_REWRITE Security Model 15-1
15.2 Summary of DBMS_ADVANCED_REWRITE Subprograms 15-1
15.2.1 ALTER_REWRITE_EQUIVALENCE Procedure 15-2
15.2.2 BUILD_SAFE_REWRITE_EQUIVALENCE Procedure 15-3
15.2.3 DECLARE_REWRITE_EQUIVALENCE Procedures 15-3
15.2.4 DROP_REWRITE_EQUIVALENCE Procedure 15-5
15.2.5 VALIDATE_REWRITE_EQUIVALENCE Procedure 15-6
16
DBMS_ADVISOR
16.1 DBMS_ADVISOR Deprecated Subprograms 16-2
16.2 DBMS_ADVISOR Security Model 16-2
16.3 Summary of DBMS_ADVISOR Subprograms 16-2
16.3.1 ADD_SQLWKLD_REF Procedure 16-6
16.3.2 ADD_SQLWKLD_STATEMENT Procedure 16-7
16.3.3 ADD_STS_REF Procedure 16-10
16.3.4 CANCEL_TASK Procedure 16-10
16.3.5 COPY_SQLWKLD_TO_STS Procedure 16-11
16.3.6 CREATE_FILE Procedure 16-12
16.3.7 CREATE_OBJECT Procedure 16-14
16.3.8 CREATE_SQLWKLD Procedure 16-15
16.3.9 CREATE_TASK Procedures 16-17
16.3.10 DELETE_SQLWKLD Procedure 16-19
16.3.11 DELETE_SQLWKLD_REF Procedure 16-20
16.3.12 DELETE_SQLWKLD_STATEMENT Procedure 16-21
16.3.13 DELETE_STS_REF Procedure 16-22
16.3.14 DELETE_TASK Procedure 16-23
16.3.15 EXECUTE_TASK Procedure 16-23
v
剩余5183页未读,继续阅读
walker_lc
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- 2023年中国辣条食品行业创新及消费需求洞察报告.pptx
- 2023年半导体行业20强品牌.pptx
- 2023年全球电力行业评论.pptx
- 2023年全球网络安全现状-劳动力资源和网络运营的全球发展新态势.pptx
- 毕业设计-基于单片机的液体密度检测系统设计.doc
- 家用清扫机器人设计.doc
- 基于VB+数据库SQL的教师信息管理系统设计与实现 计算机专业设计范文模板参考资料.pdf
- 官塘驿林场林防火(资源监管)“空天地人”四位一体监测系统方案.doc
- 基于专利语义表征的技术预见方法及其应用.docx
- 浅谈电子商务的现状及发展趋势学习总结.doc
- 基于单片机的智能仓库温湿度控制系统 (2).pdf
- 基于SSM框架知识产权管理系统 (2).pdf
- 9年终工作总结新年计划PPT模板.pptx
- Hytera海能达CH04L01 说明书.pdf
- 数据中心运维操作标准及流程.pdf
- 报告模板 -成本分析与报告培训之三.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论1