Contents at a Glance
About the Author ...................................................................................................xvii
About the Technical Reviewer ................................................................................xix
Acknowledgments ..................................................................................................xxi
Foreword ..............................................................................................................xxiii
Introduction (The Big Picture) ...............................................................................xxv
■■Chapter 1: Relational SQL ...................................................................................... 1
■■Chapter 2: Blocks, Functions, and Procedures .................................................... 37
■■Chapter 3: Types, Variables, and Scope ............................................................... 61
■■Chapter 4: Single Row Processing ...................................................................... 87
■■Chapter 5: Multirow Processing ........................................................................ 119
■■Chapter 6: Object-Relational SQL ...................................................................... 151
■■Chapter 7: Troubleshooting ............................................................................... 197
■■Chapter 8: Testing .............................................................................................. 257
■■Chapter 9: Documenting .................................................................................... 327
■■Chapter 10: Examples ........................................................................................ 365
■■Appendix A: How to Download, Install, and Use Oracle ..................................... 425
Index ..................................................................................................................... 447