Summary
The second edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle9i Release 2 features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital information from the larger book into an accessible quick-reference to fundamental language elements (e.g., block structure, identifiers, variables, datatypes, and declarations); statements for program control, cursor management, and exception handling; the basics of records, procedures, functions, triggers, and packages; and the calling of PL/SQL functions in SQL. It also includes Oracle's object-oriented features, collections, external procedures, Java integration, and such Oracle9i elements as new timestamp and interval datatypes, CASE statements and expressions, native compilation of PL/SQL, pipelined table functions, object type inheritance, upcasting/downcasting of subtypes, nested collections, and much more. Book jacket.
Author Biography
Steven Feuerstein has adopted PL/SQL as a member of his immediate family. Pay them both a visit at http://www.stevenfeuerstein.com. Bill Pribyl is thankful if his writing and lectures about PL/SQL make things a little bit easier for Oracle users. Chip Dawes is a DBA and PL/SQL developer consultant in the Chicago area.
Table of Contents
| Introduction |
|
1 | (1) |
|
PL/SQL Language Fundamentals |
|
|
2 | (7) |
|
|
|
2 | (1) |
|
|
|
3 | (1) |
|
Boolean, Numeric, and String Literals |
|
|
3 | (1) |
|
Datetime Interval Literals (Oracle9i) |
|
|
4 | (1) |
|
|
|
5 | (1) |
|
|
|
6 | (1) |
|
|
|
7 | (1) |
|
|
|
7 | (1) |
|
|
|
8 | (1) |
|
Variables and Program Data |
|
|
9 | (11) |
|
|
|
10 | (5) |
|
|
|
15 | (1) |
|
|
|
15 | (1) |
|
Implicit Datatype Conversions |
|
|
16 | (1) |
|
|
|
16 | (1) |
|
|
|
16 | (3) |
|
|
|
19 | (1) |
|
Programmer-Defined Subtypes |
|
|
20 | (1) |
|
Conditional and Sequential Control |
|
|
20 | (5) |
|
Conditional Control Statements |
|
|
20 | (4) |
|
Sequential Control Statements |
|
|
24 | (1) |
|
|
|
25 | (4) |
|
|
|
26 | (1) |
|
|
|
26 | (1) |
|
|
|
27 | (1) |
|
|
|
27 | (1) |
|
REPEAT UNTIL Loop Emulation |
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
28 | (1) |
|
|
|
29 | (4) |
|
|
|
29 | (3) |
|
|
|
32 | (1) |
|
|
|
33 | (11) |
|
|
|
33 | (4) |
|
|
|
37 | (3) |
|
|
|
40 | (1) |
|
|
|
41 | (2) |
|
|
|
43 | (1) |
|
|
|
44 | (6) |
|
|
|
44 | (2) |
|
|
|
46 | (1) |
|
|
|
47 | (1) |
|
|
|
47 | (3) |
|
|
|
50 | (3) |
|
|
|
50 | (1) |
|
Referencing Fields of Records |
|
|
51 | (1) |
|
|
|
52 | (1) |
|
|
|
53 | (1) |
|
|
|
53 | (12) |
|
|
|
54 | (1) |
|
|
|
54 | (2) |
|
|
|
56 | (9) |
|
|
|
65 | (4) |
|
|
|
65 | (3) |
|
|
|
68 | (1) |
|
|
|
68 | (1) |
|
|
|
69 | (1) |
|
|
|
69 | (1) |
|
|
|
69 | (5) |
|
|
|
70 | (2) |
|
Referencing Package Elements |
|
|
72 | (1) |
|
|
|
72 | (1) |
|
|
|
73 | (1) |
|
|
|
73 | (1) |
|
Calling PL/SQL Functions in SQL |
|
|
74 | (3) |
|
|
|
75 | (1) |
|
Requirements and Restrictions |
|
|
76 | (1) |
|
Calling Packaged Functions in SQL |
|
|
76 | (1) |
|
Column/Function Name Precedence |
|
|
77 | (1) |
|
Oracle's Object-Oriented Features |
|
|
77 | (13) |
|
|
|
78 | (2) |
|
Type Inheritance (Oracle9i) |
|
|
80 | (1) |
|
|
|
80 | (3) |
|
Methods in Subtypes (Oracle9i) |
|
|
83 | (1) |
|
Manipulating Objects in PL/SQL and SQL |
|
|
84 | (1) |
|
Upcasting and Downcasting (Oracle9i) |
|
|
85 | (3) |
|
|
|
88 | (2) |
|
|
|
90 | (12) |
|
|
|
91 | (1) |
|
|
|
92 | (2) |
|
Adding and Removing Elements |
|
|
94 | (1) |
|
Collection Pseudo-Functions |
|
|
94 | (1) |
|
|
|
95 | (3) |
|
Collections and Privileges |
|
|
98 | (1) |
|
Nested Collections (Oracle9i) |
|
|
98 | (1) |
|
|
|
98 | (4) |
|
|
|
102 | (9) |
|
Creating an External Procedure |
|
|
102 | (5) |
|
|
|
107 | (4) |
|
Java Language Integration |
|
|
111 | (4) |
|
|
|
113 | (1) |
|
Publishing Java to PL/SQL |
|
|
114 | (1) |
|
|
|
115 | (1) |
|
|
|
115 | (2) |
| Index |
|
117 | |
Other versions by this Author
