The PLSQL Challenge 15 Key Tips Everyone Must Know

Maclean Liu(刘相兵

The PLSQL Challenge 15 Key Tips Everyone Must Know

PL/SQL Objects and Pragma
Impact Analysis
PL/SQL Compilation
Encrypting PL/SQL
Autonomous Transactions


Oracle provides a dependency mapping in the database that allows impact analysis to be performed on the database stored objects.


Oracle Dependencies are Created in the Database Everytime an Object is Created
Dependencies can be Viewed in the USER_DEPENDENCIES view
One Record is Stored for Each Dependency
Dependencies are One Level When Queried


A More Complete Multi-Level Dependency Map can be Created from the View
Package dependency_tree
Procedure find_dep
Top Down or Bottom Up Dependency Mapping
Input Parameters
p_direction_type: T for Top Down or B for Bottom Up
p_object_name_text: Name of the Object
p_owner_txt: Name of the Owner of the Object


The PLSQL Challenge 15 Key Tips Everyone Must Know.ppt (4.93 MB, 下载次数: 1, 售价: 10 金钱)

2012-3-22 19:36 上传

点击文件名下载附件
售价: 10 金钱  [记录]