Preface |
|
xi | |
|
PL/SQL: What, When, and Where |
|
|
1 | (19) |
|
|
1 | (8) |
|
|
9 | (6) |
|
What You Need to Get Started with PL/SQL |
|
|
15 | (5) |
|
|
20 | (42) |
|
|
20 | (2) |
|
Running Your First PL/SQL Program |
|
|
22 | (4) |
|
Introduction to Program Structure |
|
|
26 | (4) |
|
|
30 | (7) |
|
|
37 | (7) |
|
|
44 | (4) |
|
Executing in Circles: Loop Statements |
|
|
48 | (6) |
|
Code Formatting: Requirements and Guidelines |
|
|
54 | (2) |
|
Some Advanced Fundamentals |
|
|
56 | (6) |
|
|
62 | (44) |
|
Some Background on the Example |
|
|
62 | (2) |
|
A First Programming Exercise |
|
|
64 | (15) |
|
Retrieving a Book Count with a Function |
|
|
79 | (4) |
|
|
83 | (6) |
|
Using PL/SQL Packages to Organize Code |
|
|
89 | (11) |
|
|
100 | (4) |
|
|
104 | (2) |
|
|
106 | (45) |
|
|
107 | (10) |
|
Using PL/SQL to Create Web Pages |
|
|
117 | (32) |
|
|
149 | (2) |
|
|
151 | (45) |
|
|
151 | (1) |
|
A Simple-Minded Approach to Retrieving One Row |
|
|
152 | (2) |
|
Retrieving More than One Row Using a Cursor |
|
|
154 | (11) |
|
Presenting Query Results via a Web Page |
|
|
165 | (5) |
|
Building a Web-Based Search Page Using Dynamic SQL |
|
|
170 | (17) |
|
Advanced Data Retrieval Topics |
|
|
187 | (9) |
|
|
196 | (29) |
|
|
196 | (13) |
|
Use Tools to Write Code Effectively |
|
|
209 | (16) |
|
Security: Keep the Bad Guys Out |
|
|
225 | (41) |
|
|
226 | (9) |
|
Organizing Accounts to Improve Security |
|
|
235 | (11) |
|
Analyzing the Library System's Requirements |
|
|
246 | (6) |
|
Keeping a Trail of Database Changes |
|
|
252 | (8) |
|
Special Security Topics for PL/SQL Developers |
|
|
260 | (6) |
|
Communicating with the Outside World |
|
|
266 | (36) |
|
Sending Internet Email from PL/SQL |
|
|
267 | (5) |
|
Using the Mail Sender in the Library System |
|
|
272 | (3) |
|
Receiving Email Inside the Database |
|
|
275 | (9) |
|
Fetching Data from a Remote Web Site |
|
|
284 | (12) |
|
Integration with Other Languages |
|
|
296 | (6) |
|
Intermediate Topics and Other Diversions |
|
|
302 | (59) |
|
Riding the Software Lifecycle |
|
|
303 | (2) |
|
Lists o'Stuff (Collections) in PL/SQL |
|
|
305 | (12) |
|
Exception-Handling Packages |
|
|
317 | (5) |
|
|
322 | (5) |
|
|
327 | (4) |
|
Managing Patron and Librarian Privileges |
|
|
331 | (20) |
|
Still More PL/SQL Features |
|
|
351 | (10) |
``Making Good'' of Database Programming |
|
361 | (6) |
|
|
361 | (2) |
|
|
363 | (1) |
|
|
364 | (1) |
|
|
365 | (2) |
Glossary |
|
367 | (14) |
Index |
|
381 | |