search for books and compare prices
Tables of Contents for Oracle Pl/SQL Programming
Chapter/Section Title
Page #
Page Count
Foreword
xv
4
Preface
xix
 
I. Programming in PL/SQL
1
82
1. Introduction to PL/SQL
3
39
What Is PL/SQL?
3
2
The Concept of Programming in Oracle Applications
5
2
The Origins of PL/SQL
7
2
PL/SQL Versions
9
20
Advice for Oracle Programmers
29
3
A Few of My Favorite (PL/SQL) Things
32
3
Best Practices for PL/SQL Excellence
35
7
2. PL/SQL Language Fundamentals
42
13
The PL/SQL Character Set
42
2
Identifiers
44
2
Literals
46
3
The Semicolon Delimiter
49
1
Comments
50
1
The PRAGMA Keyword
51
1
Block Structure
52
3
3. Effective Coding Style
55
28
Fundamentals of Effective Layout
56
7
Formatting SQL Statements
63
3
Formatting Control Structures
66
3
Formatting PL/SQL Blocks
69
2
Formatting Packages
71
1
Using Comments Effectively
72
7
Documenting the Entire Package
79
4
II. PL/SQL Language Elements
83
266
4. Variables and Program Data
85
53
Identifiers
85
2
Scalar Datatypes
87
24
NULLs in PL/SQL
111
3
Variable Declarations
114
2
Anchored Declarations
116
5
Programmer-Defined Subtypes
121
4
Tips for Creating and Using Variables
125
13
5. Conditional and Sequential Control
138
17
Conditional Control Statements
138
8
Sequential Control Statements
146
9
6. Database Interaction and Cursors
155
58
Transaction Management
155
5
Cursors in PL/SQL
160
3
Implicit and Explicit Cursors
163
4
Declaring Cursors
167
5
Opening Cursors
172
1
Fetching from Cursors
173
3
Column Aliases in Cursors
176
1
Closing Cursors
177
1
Cursor Attributes
178
6
Cursor Parameters
184
3
SELECT FOR UPDATE in Cursors
187
4
Cursor Variables
191
15
Working with Cursors
206
7
7. Loops
213
26
Loop Basics
213
3
The Simple Loop
216
2
The Numeric FOR Loop
218
3
The Cursor FOR Loop
221
5
The WHILE Loop
226
1
Managing Loop Execution
227
5
Tips for PL/SQL Loops
232
7
8. Exception Handlers
239
38
Why Exception Handling?
240
1
The Exception Section
241
2
Types of Exceptions
243
6
Determining Exception-Handling Behavior
249
8
Raising an Exception
257
5
Handling Exceptions
262
6
Client-Server Error Communication
268
2
NO_DATA_FOUND: Multipurpose Exception
270
1
Exception Handler as IF Statement
271
2
RAISE Nothing but Exceptions
273
4
9. Records in PL/SQL
277
25
Record Basics
277
6
Table-Based Records
283
1
Cursor-Based Records
284
3
Programmer-Defined Records
287
3
Assigning Values to and from Records
290
3
Record Types and Record Compatibility
293
3
Nested Records
296
6
10. PL/SQL Tables
302
47
PL/SQL Tables and Other Collections
303
1
Characteristics of PL/SQL Tables
304
1
PL/SQL Tables and DML Statements
305
1
Declaring a PL/SQL Table
306
2
Referencing and Modifying PL/SQL Table Rows
308
4
Filling the Rows of a PL/SQL Table
312
2
Clearing the PL/SQL Table
314
1
PL/SQL Table Enhancements in PL/SQL Release 2.3
315
7
Working with PL/SQL Tables
322
27
III. Built-In Functions
349
114
11. Character Functions
351
42
Character Function Descriptions
352
22
Character Function Examples
374
19
12. Date,Functions
393
17
Date Function Descriptions
394
10
Date Function Examples
404
6
13. Numeric, LOB, and Miscellaneous Functions
410
21
Numeric Function Descriptions
412
7
LOB Function Descriptions
419
4
Miscellaneous Function Descriptions
423
8
14. Conversion Functions
431
32
Conversion Formats
432
4
Conversion Function Descriptions
436
5
Conversion Function Examples
441
22
IV. Modular Code
463
116
15. Procedures and Functions
465
53
Modular Code
466
1
Review of PL/SQL Block Structure
467
2
The Anonymous PL/SQL Block
469
15
Procedures
484
3
Functions
487
8
Parameters
495
10
Local Modules
505
4
Module Overloading
509
6
Forward Declarations
515
2
Go Forth and Modularize!
517
1
16. Packages
518
31
The Benefits of Packages
519
2
Overview of Package Structure
521
9
The Package Specification
530
7
The Package Body
537
3
Package Data
540
5
Package Initialization
545
4
17. Calling PL/SQL Functions in SQL
549
30
Looking at the Problem
549
3
Syntax for Calling Stored Functions in SQL
552
1
Requirements for Stored Functions in SQL
553
1
Restrictions on PL/SQL Functions in SQL
554
2
Calling Packaged Functions in SQL
556
4
Column/Function Name Precedence
560
1
Realities: Calling PL/SQL Functions in SQL
561
3
Examples of Embedded PL/SQL
564
15
V. New PL/SQL8 Features
579
178
18. Object Types
581
66
Introduction to Oracle8 Objects
582
11
Oracle Objects Example
593
9
Syntax for Creating Object Types
602
13
Manipulating Objects in PL/SQL and SQL
615
10
Modifying Persistent Objects
625
15
Object Housekeeping
640
4
Making the Objects Option Work
644
3
19. Nested Tables and VARRAYs
647
44
Types of Collections
648
4
Creating the New Collections
652
7
Syntax for Declaring Collection Datatypes
659
2
Using Collections
661
9
Collection Pseudo-Functions
670
8
Collection Built-Ins
678
7
Example: PL/SQL-to-Server Integration
685
2
Collections Housekeeping
687
2
Which Collection Type Should I Use?
689
2
20. Object Views
691
29
Example: Using Object Views
693
4
INSTEAD OF Triggers
697
4
Syntax for Object Views
701
3
Differences Between Object Views and Object Tables
704
9
Not All Views with Objects Are Object Views
713
1
Schema Evolution
713
2
Object Views Housekeeping
715
2
Postscript: Using the BFILE Datatype
717
3
21. External Procedures
720
37
Introduction to External Procedures
721
5
Steps in Creating an External Procedure
726
7
Syntax for External Procedures
733
3
Mapping Parameters
736
8
OCI Service Routines
744
1
External Procedure Housekeeping
744
3
Examples
747
10
VI. Making PL/SQL Programs Work
757
152
22. Code Design Tips
759
44
Select Meaningful Module and Parameter Names
760
4
Build the Most Functional Functions
764
14
Take Full Advantage of Local Modularization
778
2
Be Wary of Modules Without Any Parameters
780
2
Create Independent Modules
782
4
Construct Abstract Data Types (ADTs)
786
8
Tips for Parameter Design
794
9
23. Managing Code in the Database
803
30
Executing Stored Code
804
5
Transaction Integrity and Execute Authority
809
3
Module Validation and Dependency Management
812
2
Remote Procedure Calls
814
2
Managing Stored Objects with SQL*Plus
816
4
Using SQL to Examine Stored Objects
820
9
Encrypting Stored Code
829
4
24. Debugging PL/SQL
833
16
The Wrong Way to Debug
834
2
Debugging Tips and Strategies
836
13
25. Tuning PL/SQL Applications
849
45
Analyzing Program Performance
850
3
Tuning Access to Compiled Code
853
5
Tuning Access to Your Data
858
13
Tuning Your Algorithms
871
21
Overview of PL/SQL8 Enhancements
892
2
26. Tracing PL/SQL Execution
894
15
The PL/SQL Trace Facility
894
4
Tracing for Production Support
898
4
Free Format Filtering
902
1
Structured Interface Filtering
903
1
Quick-and-Dirty Tracing
904
5
VII. Appendixes
909
56
A. What's on the Companion Disk?
911
4
B. Calling Stored Procedures from PL/SQL Version 1.1
915
8
C. Built-In Packages
923
42
Index
965