Oracle9i: Advanced PL/SQL

 Oracle University provides a downloadable eKit containing the training materials for this course.

您将学到什么内容:

The objective of this course is to teach you how to use some of the advanced features of PL/SQL. Using advanced features of packages, cursors, extended interface methods, and advanced object types, you will learn how to write powerful and efficient PL/SQL programs.

You will learn concepts that help you to design and tune subprograms, advanced interface methods to C functions and Java methods, to use and incorporate Oracle objects within applications, some of the advanced features of the Oracle supplied packages, how to create, run, and edit PL/SQL server pages and features of fine grained access.

This course counts towards the Hands-on course requirement for the Oracle 9i Database Administrator and Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

时间表/定购	培训形式	价格	持续时间	培训课程教材	使用说明语言
查看课程时间表	教师指导的课堂培训	CNY 6555	3 天	英文

 

注意: 享受更多个性化体验, 我们邀请您到: 登录!

先决条件:

必要的先决条件:

 
• Introduction to Oracle9i: SQL
 

课程目标:

• Create PL/SQL applications that use Oracle objects
• Implement Oracle9i features to create large, complex and effective applications
• Design PL/SQL packages and program units that execute efficiently
• Write and tune PL/SQL code effectively to maximize performance
• Write code to interface with external applications and the operating system
• Use some of the advanced features of the supplied built-in packages to implement a wide range of functionality

课程主题:

Design Considerations for PL/SQL Program Units

• Cursor Variables
• REF CURSOR
• Predefined Data Types
• Local Subprograms
• The NOCOPY Compiler Hint
• The DETERMINISTIC Hint
• Definer and Invoker Rights

Design Considerations for PL/SQL Packages

• Package Memory Issues and Reusability
• Rules for Programs SERIALLY_REUSABLE
• Restrictions on Package Functions Used in SQL
• Using Overloading
• Standardizing Constants and Exceptions
• PL/SQL Wrapper

Advanced Interface Methods

• Multi-Language Programs
• External Procedures
• The extproc and Listener Process
• External C Procedures
• PL/SQL and Java

Object-Oriented Principles Overview

• Objects
• Encapsulation
• Object Hierarchies
• Object Types
• Inheritance
• Polymorphism

Working with Oracle Objects

• Structure of an Object Type
• Object Methods
• Using Methods in PL/SQL
• Object Tables
• Using REF and DEREF
• Type Inheritance
• Data Dictionary Views for Objects and Object Type Methods

Working with Collections

• Collection Types
• Nested Tables and VARRAYs
• Using Collection Methods
• Avoiding Collection Exceptions
• Using Collections Effectively
• Index-By Tables

Performance and Tuning

• Tuning PL/SQL Code
• The RETURNING Clause
• Bulk Binding and Handling FORALL Exceptions
• Native Dynamic SQL
• Tracing PL/SQL Execution
• Profiling PL/SQL Applications
• Identify and Tune Memory Issues
• Pinning Objects

Using the Advanced Features of the Oracle Supplied Packages

• Using dbms_session
• The dbms_lock Package
• utl_smtp Package

PL/SQL Server Pages

• PSP: Uses and Features
• Format of the PSP File
• Development Steps for PSP
• Using an HTML Form to Call a PSP
• Debugging PSP Problems

Fine-Grained Access Control

• How Fine Grained Access Works
• DBMS_RLS Package
• Implementing a Policy
• USER_CONTEXT Dictionary View
• Policy Groups