Share
Create bookmark
Oracle PL/SQL Programming
Notes
Please login to add notes
- Table of Contents
-
+
Preface
-
+
Part I. Programming in PL/SQL
-
+
Chapter 1. Introduction to PL/SQL
- What Is PL/SQL?
- + The Origins of PL/SQL
- + So This Is PL/SQL
-
+
About PL/SQL Versions
-
+
Oracle Database 11g New Features
- Edition-based redefinition capability (Release 2 only)
- FORCE option with CREATE TYPE (Release 2 only)
- Function result cache
- CONTINUE statement
- Sequences in PL/SQL expressions
- Dynamic SQL enhancements
- New native compilation and SIMPLE datatypes
- SecureFiles
- Trigger enhancements
- Automatic subprogram inlining
- PL/Scope
- PL/SQL hierarchical profiler
- Fine-grained dependency tracking
- Supertype invocation from subtype
-
+
Oracle Database 11g New Features
- + Resources for PL/SQL Developers
- + Some Words of Advice
- + Chapter 2. Creating and Running PL/SQL Code
- + Chapter 3. Language Fundamentals
-
+
Chapter 1. Introduction to PL/SQL
-
+
Part II. PL/SQL Program Structure
-
+
Chapter 4. Conditional and Sequential Control
-
+
Chapter 5. Iterative Processing with Loops
-
+
Chapter 6. Exception Handlers
-
+
Chapter 4. Conditional and Sequential Control
-
+
Part III. PL/SQL Program Data
- + Chapter 7. Working with Program Data
-
+
Chapter 8. Strings
-
+
Chapter 9. Numbers
-
+
Chapter 10. Dates and Timestamps
-
+
Chapter 11. Records
-
+
Chapter 12. Collections
- + Chapter 13. Miscellaneous Datatypes
-
+
Part IV. SQL in PL/SQL
-
+
Part V. PL/SQL Application Construction
- + Chapter 17. Procedures, Functions, and Parameters
-
+
Chapter 18. Packages
- + Chapter 19. Triggers
-
+
Chapter 20. Managing PL/SQL Code
-
+
Managing Code in the Database
- Overview of Data Dictionary Views
- Display Information About Stored Objects
- Display and Search Source Code
- Use Program Size to Determine Pinning Requirements
- Obtain Properties of Stored Code
- Analyze and Modify Trigger State Through Views
- Analyze Argument Information
- Analyze Identifier Usage (Oracle Database 11g’s PL/Scope)
-
+
Managing Dependencies and Recompiling Code
-
+
Compile-Time Warnings
- A Quick Example
- Enabling Compile-Time Warnings
-
+
Some Handy Warnings
- PLW-05000: Mismatch in NOCOPY qualification between specification and body
- PLW-05001: Previous use of ’string’ (at line string) conflicts with this use
- PLW-05003: Same actual parameter (string and string) at IN and NOCOPY may have side effects
- PLW-05004: Identifier string is also declared in STANDARD or is a SQL built-in
- PLW-05005: Function string returns without value at line string
- PLW-06002: Unreachable code
- PLW-07203: Parameter 'string' may benefit from use of the NOCOPY compiler hint
- PLW-07204: Conversion away from column type may result in suboptimal query plan
- PLW-06009: Procedure “string” OTHERS handler does not end in RAISE or RAISE_APPLICATION_ERROR (Oracle Database 11g)
- + Testing PL/SQL Programs
- + Tracing PL/SQL Execution
-
+
Debugging PL/SQL Programs
- + Protecting Stored Code
- Introduction to Edition-Based Redefinition (Oracle Database 11g Release 2)
-
+
Managing Code in the Database
-
+
Chapter 21. Optimizing PL/SQL Performance
- + Tools to Assist in Optimization
- + The Optimizing Compiler
-
+
Data Caching Techniques
- + Package-Based Caching
- Deterministic Function Caching
-
+
Function Result Cache (Oracle Database 11g)
- How to use the function result cache
- The RELIES_ON clause
- Function result cache example: A deterministic function
- Function result cache example: Querying data from a table
- Function result cache example: Caching a collection
- When to use the function result cache
- When not to use the function result cache
- Useful details of function result cache behavior
- Managing the function result cache
- The Virtual Private Database and function result caching
- Caching Summary
- + Bulk Processing for Multirow SQL
-
+
Improving Performance With Pipelined Table Functions
- + Replacing Row-Based Inserts with Pipelined Function-Based Loads
- + Tuning Merge Operations with Pipelined Functions
- + Asynchronous Data Unloading with Parallel Pipelined Functions
- + Performance Implications of Partitioning and Streaming Clauses in Parallel Pipelined Functions
- + Pipelined Functions and the Cost-Based Optimizer
- + Tuning Complex Data Loads with Pipelined Functions
- A Final Word on Pipelined Functions
-
+
Specialized Optimization Techniques
- Stepping Back for the Big Picture on Performance
-
+
Chapter 22. I/O and PL/SQL
- + Displaying Information
- + Reading and Writing Files
-
+
Sending Email
- Oracle Prerequisites
- Configuring Network Security
- Send a Short (32,767 or Less) Plaintext Message
- Include “Friendly” Names in Email Addresses
- Send a Plaintext Message of Arbitrary Length
- Send a Message with a Short (< 32,767) Attachment
- Send a Small File (< 32767) as an Attachment
- Attach a File of Arbitrary Size
- + Working with Web-Based Data (HTTP)
- + Other Types of I/O Available in PL/SQL
-
+
Part VI. Advanced PL/SQL Topics
-
+
Chapter 23. Application Security and PL/SQL
- Security Overview
-
+
Encryption
- Key Length
- Algorithms
- Padding and Chaining
- + The DBMS_CRYPTO Package
- Encrypting Data
- Encrypting LOBs
- SecureFiles
- Decrypting Data
- Performing Key Generation
- + Performing Key Management
- Cryptographic Hashing
- Using Message Authentication Codes
- Using Transparent Data Encryption (TDE)
- Transparent Tablespace Encryption
-
+
Row-Level Security
- + Application Contexts
- + Fine-Grained Auditing
- + Chapter 24. PL/SQL Architecture
- + Chapter 25. Globalization and Localization in PL/SQL
-
+
Chapter 26. Object-Oriented Aspects of PL/SQL
- + Chapter 27. Calling Java from PL/SQL
- + Chapter 28. External Procedures
-
+
Chapter 23. Application Security and PL/SQL
- + Appendix A. Regular Expression Metacharacters and Function Parameters
- Appendix B. Number Format Models
- Appendix C. Date Format Models
- Index
This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of _Oracle PL/SQL Programming_ covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. >
This indispensable reference for both novices and experienced Oracle programmers will help you: * Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code * Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition * Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture * Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL * Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects * Build modular PL/SQL applications using procedures, functions, triggers, and packages
Test the closed alpha on paperc.com
Book Details
Authors
Steven Feuerstein and Bill Pribyl
Categories
Computers > Programming Languages > SQL
Publishers
Publication year : 2009
License: All rights reserved ©
Times read: 544
