Flylib.com
Oracle PL/SQL Programming: Guide to Oracle8i Features
Oracle PL/SQL Programming: Guide to Oracle8i Features
ISBN: B000H2MK2W
EAN: N/A
Year: 1998
Pages: 107
Authors:
Steven Feuerstein
BUY ON AMAZON
Main
TOC
Copyright
Dedication
Preface
Structure of This Book
About the Examples
About the Disk
Conventions Used in This Book
How to Contact Us
Acknowledgments
Chapter 1. Oracle8i: A Bounty for PLSQL Developers
1.1 What s in Oracle8i Release 8.1?
1.2 And Then There s Java
1.3 New PLSQL Features Roundup
Chapter 2. Choose Your Transaction
2.1 Transaction Management in PLSQL
2.2 Defining Autonomous Transactions
2.3 When to Use Autonomous Transactions
2.4 Rules and Restrictions
2.5 Examples
Chapter 3. Invoker Rights: Your Schema or Mine?
3.1 A Look at the Definer Rights Model
3.2 The Invoker Rights Model
Invoker Rights for Dynamic SQLH2 P classdoc
3.4 Combining the Definer and Invoker Rights Models
Chapter 4. Native Dynamic SQL in Oracle8i
4.1 DBMS_SQL Versus NDS
4.2 NDS Statement Summary
4.3 Multirow Queries with Cursor Variables
4.4 Binding Variables
4.5 Working with Objects and Collections
4.6 Building Applications with NDS
4.7 NDS Utility Package
Chapter 5. Bulking Up with PLSQL 8.1
5.1 Context-Switching Problem Scenarios
5.2 Bulk DML with the FORALL Statement
5.3 Bulk Querying with the BULK COLLECT Clause
5.4 Using Cursor Attributes
5.5 Analyzing the Impact of Bulk Operations
Chapter 6. New Trigger Features in Oracle8i
6.1 Triggers on Nested Table View Columns
6.2 Database-Level Event Triggers
6.3 Schema-Level Event Triggers
Chapter 7. New and Enhanced Built-in Packages in Oracle8i
7.1 DBMS_PROFILER: Providing Code Profiling
7.2 DBMS_TRACE: Providing a PLSQL Trace Facility
7.3 DBMS_RLS: Implementing Fine-Grained Access Control
7.4 UTL_COLL: Using Collection Locators
7.5 LOB Enhancements
7.6 New DBMS_AQ and DBMS_AQADM Features
7.7 New DBMS_UTILITY Features
Chapter 8. Deploying Fine-Grained Access Control
8.1 FGAC Components
8.2 CREATE CONTEXT: Creating Contexts
8.3 SET_CONTEXT: Setting Context and Attribute Values
8.4 SYS_CONTEXT and LIST_CONTEXT: Obtaining Context Information
8.5 A Complete FGAC Example
Chapter 9. Calling Java from PLSQL
9.1 Oracle8i and Java
9.2 Getting Ready to Use Java in Oracle
9.3 A Simple Demonstration
9.4 Using loadjava
9.5 Using dropjava
9.6 Managing Java in the Database
9.7 Using DBMS_JAVA and DBMS_JAVA_TEST
9.8 Publishing and Using Java in PLSQL
9.9 Examples
Chapter 10. More Goodies for Oracle8i PLSQL Developers
10.1 The NOCOPY Parameter Mode Hint
10.2 Calling Packaged Functions in SQL
10.3 SQL99 Compliance
10.4 SQL Operations on Collections
10.5 Miscellaneous and Minor Improvements
Appendix A. Appendix: What s on the Companion Disk?
A.1 Installing the Reference
A.2 Using the Reference
Colophon
INDEX
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Oracle PL/SQL Programming: Guide to Oracle8i Features
ISBN: B000H2MK2W
EAN: N/A
Year: 1998
Pages: 107
Authors:
Steven Feuerstein
BUY ON AMAZON
Oracle Developer Forms Techniques
Timers and Displaying a Clock
Querying by Nonbase Table Items
Base Tables
Polymorphism
Enhancing the Function of Exit Form
Network Security Architectures
Confidentiality and Security Are Not the Same
IP Addressing Design Considerations
Identity Considerations
Hardware-Based Teleworker Design
NetGamesRUs.com
Systematic Software Testing (Artech House Computer Library)
An Overview of the Testing Process
Master Test Planning
Analysis and Design
Appendix E Simplified Unit Test Plan
Appendix F Process Diagrams
C++ How to Program (5th Edition)
Placing a Class in a Separate File for Reusability
Case Study: Game of Chance and Introducing enum
Exercises
Summary
J.5. Linking
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
An Introduction to the Lotus Domino Tool Suite
What Is Formula Language?
Working with Iterative Loops
Elements of a Project Schedule
Check for an Element in an Array
DNS & BIND Cookbook
Getting a List of Top-Level Domains
Starting a Name Server
Moving a Host
Sending TSIG-Signed Dynamic Updates
Introduction
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies