ORACLE核心应用技术研究.doc

OracleERP最佳技术实践
E-BusinessSuite
Oracle关键应用技术
DB、PL/SQL要点荟萃

Author: 黄建华Jianhua.Huang
MSN:
CreationDate: createdate\@"MMMMd,yyyy"October16,2023
LastUpdated: savedate\@"MMMMd,yyyy"February16,2023
DocumentRef: <DocumentReferenceNumber>
Version: DRAFT1A

Approvals:
<Approver1><Approver2>autotext"PICOracleLogo"\*Mergeformat CopyNumber _____

DocumentControl

ChangeRecord
SECTIONPAGES\*MERGEFORMAT5
DateAuthorVersionChangeReferenceCREATEDATE\@"d-MMM-yy"16-Oct-06Jianhua.HuangDraft1aNoPreviousDocument

Reviewers

NamePosition

Distribution

CopyNo.NameLocationLibraryMasterProjectLibraryProjectManager
NoteToHolders:
Ifyoureceiveanelectroniccopyofthisdocumentandprintitout,pleasewriteyournameontheequivalentofthecoverpage,fordocumentcontrolpurposes.
Ifyoureceiveahardcopyofthisdocument,pleasewriteyournameonthefrontcover,fordocumentcontrolpurposes.
Contents
TOC\o"2-3"DocumentControl PAGEREF_Toc\hii
1. 特殊值、特殊字段、特殊对象、特殊语句 PAGEREF_Toc\h2
1.1. Null值 PAGEREF_Toc\h2
1.2. With语句 PAGEREF_Toc\h2
1.3. SQL%变量 PAGEREF_Toc\h3
1.4. Sequence PAGEREF_Toc\h3
1.5. Table() PAGEREF_Toc\h3
2. 连接处理：嵌套循环、Hash、排序合并 PAGEREF_Toc\h5
2.1. 外连接 PAGEREF_Toc\h5
3. Transaction事务 PAGEREF_Toc\h6
3.1. 回忆事务 PAGEREF_Toc\h6
3.2. 自治事务 PAGEREF_Toc\h6
3.3. 分布式事务和两阶段提交 PAGEREF_Toc\h8
4. Lock锁、Session会话、Process进程 PAGEREF_Toc\h10
4.1. Lock演示和检查 PAGEREF_Toc\h10
4.2. 会话、进程、祈求 PAGEREF_Toc\h11
5. 自带旳ApplicationServer PAGEREF_Toc\h13
5.1. OC4J概述 PAGEREF_Toc\h13
5.2. 配置和公布 PAGEREF_Toc\h14
6. MODPL/SQL PAGEREF_Toc\h17
6.1. MODPL/SQ基础 PAGEREF_Toc\h17
7. Java PAGEREF_Toc\h18
7.1. 直接作为Procedure PAGEREF_Toc\h18
8. 物化视图、高级复制 PAGEREF_Toc\h19
8.1. 快照自动更新 PAGEREF_Toc\h19
8.2. 高级复制基础 PAGEREF_Toc\h20
8.3. 单主异步可更新MV PAGEREF_Toc\h24
8.4. 多主异步复制 PAGEREF_Toc\h30
8.5. 多主同步复制 PAGEREF_Toc\h35
8.6. 其他常用SQL PAGEREF_Toc\h36
9. 计划任务：DBMS_JOB、DBMS_SCHEDULER PAGEREF_Toc\h39
9.1. DBMS_JOB PAGEREF_Toc\h39
9.2. DBMS_JOB PAGEREF_Toc\h39