Home Page Icon
Home Page
Table of Contents for
Expert PL/SQL Practices: for Oracle Developers and DBAs
Close
Expert PL/SQL Practices: for Oracle Developers and DBAs
by Riyaj Shamsudeen, Ron Sands, Michael Rosenblum, Stephan Petit, Arup Nanda, Conno
Expert PL/SQL Practices for Oracle Developers and DBAs
Title
Contents at a Glance
Contents
About the Authors
About the Technical Reviewers
Introduction
Chapter 1: Do Not Use
Row-by-Row Processing
Nested Row-by-Row Processing
Lookup Queries
Excessive Access to DUAL
Excessive Function Calls
Database Link Calls
Excessive Use of Triggers
Excessive Commits
Excessive Parsing
Summary
Chapter 2: Dynamic SQL: Handling the Unknown
The Hero
Sample of Dynamic Thinking
Security Issues
Performance and Resource Utilization
Object Dependencies
Summary
Chapter 3: PL/SQL and Parallel Processing
Why Parallel Processing?
Laws Affecting Parallel Processing
The Rise of Big Data
Parallel vs. Distributed Processing
Parallel Hardware Architectures
Identify Your Goals
Candidate Workloads for Parallel Processing
The MapReduce Programming Model
Before Looking to PL/SQL
Processes Available for Parallel Activities
Using Parallel Execution Servers for MapReduce
Summary
Chapter 4: Warnings and Conditional Compilation
PL/SQL Warnings
Conditional Compilation
Summary
Chapter 5: PL/SQL Unit Testing
Why Test Your Code?
What Is Unit Testing?
Tools for Building Unit Tests
Preparing and Maintaining the Unit Test Environment
Building Unit Tests
Broadening the Scope of the Tests
Supporting Unit Test Features
Running Tests from the Command Line
Summary
Chapter 6: Bulk SQL Operations
The Hardware Store
Setting for the Examples in this Chapter
Bulk Operations in PL/SQL
Bulk Binding
Error Handling with Bulk Bind
A Justification for Massive Collections
The Real Benefit: Client Bulk Processing
Summary
Chapter 7: Know Your Code
What This Chapter Will (and Will Not) Cover
Automated Code Analysis
When to Analyze?
Performing Static Analysis
Performing Dynamic Analysis
Summary
Chapter 8: Contract-Oriented Programming
Design by Contract
Implementing PL/SQL Contracts
Example: Testing Odd and Even Integers
Useful Contract Patterns
Principles For Bug-Free Code
Summary
Chapter 9: PL/SQL from SQL
The Cost of Using PL/SQL Functions in SQL
Reducing the Cost of PL/SQL Functions
Summary
Chapter 10: Choosing the Right Cursor
Explicit Cursors
Implicit Cursors
Static REF Cursors
Dynamic REF Cursors
Summary
Chapter 11: PL/SQL Programming in the Large
The Database as PL/SQL-Based Application Server
Requirements of Programming in the Large
Uniformity through Conventions
Modularization of Code and Data
Object-Oriented Programming with PL/SQL
Memory Management
Summary
Chapter 12: Evolutionary Data Modeling
Lessons from Two Decades of System Development
The Database and Agile Development
Evolutionary Data Modeling
Refactoring the Database
Creating an Access Layer via PL/SQL
The Agile Manifesto
Using PL/SQL with Evolutionary Data Modeling
Summary
Chapter 13: Profiling for Performance
What Is Performance?
What Is Profiling?
Instrumentation
Problem Diagnosis
Summary
Chapter 14: Coding Conventions and Error Handling
Why coding conventions?
Formatting
Dynamic Code
Packages
Stored Procedures
Functions
Error Handling
Summary
Chapter 15: Dependencies and Invalidations
Dependency Chains
Shortening Dependency Chains
Datatype Reference
View for Table Alterations
Adding Components into Packages
Synonyms in Dependency Chains
Resource Locking
Forcing Dependency in Triggers
Creating Triggers Disabled Initially
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset