Oracle PL/SQL Programming, Third Edition

Acknowledgments

Since Oracle PL/SQL Programming was first published in 1995, it has had a busy and productive history as the “go to” text on how to use the PL/SQL language. For that, we first of all express our appreciation to all of our readers.

Maintaining Oracle PL/SQL Programming as an accurate, readable, and up-to-date reference to PL/SQL has, from the start, been a big (all right, we admit it—sometimes overwhelming) job; it certainly would not have been possible without the help of many Oracle specialists, friends, and family, and of course the incredible staff at O’Reilly & Associates.

You will find below rather detailed thank yous for those who helped pull together the third edition of Oracle PL/SQL Programming. Following that, you will find an acknowledgment of the many people who were instrumental in the first and second editions. If you want to read the full text of the acknowledgments from these earlier editions, please visit the web site.

First and foremost, we thank Jonathan Gennick, Darryl Hurley, Bryn Llewellyn, and Steve Adams, four outstanding Oracle technologists, for their substantial contributions to this book. Jonathan wrote or substantially updated five chapters, and Darryl contributed the fine chapter on database triggers and contributed many insights on Oracle’s internationalization features. Bryn Llewellyn, Oracle’s PL/SQL Product Manager, provided crucial information on Oracle9i’s new features, answered endless questions about various PL/SQL features with bottomless patience, and reviewed a large number of chapters. Steve gave us excellent and detailed feedback on PL/SQL’s runtime architecture.

With such a big book, we needed lots of reviewers, especially because we asked them to test each code snippet and program in the book to keep to an absolute minimum the number of errors that made it into the printed version. We are deeply grateful to the following men and women of the Oracle PL/SQL world, who took time away from the rest of their lives to help make Oracle PL/SQL Programming the best book it could be: Don Bales, Dick Bolz, Dan Clamage, Steve Cosner, Gerard Hartgers, Dwayne King, Larry Elkins, Chandrasekharan Iyer, Vadim Loevski, Giovanni Jaramillo, Rakesh Patel, James Padfield, Peter Linsley, Christopher Racicot, Alex Romankevich, Scott Sowers, JT Thomas, Edward Van Hatten, Simon St. Laurent, Tony Crawford, Geoff Chester, and Andre Vergison.

Once we felt good about the technical content, it was time for the remarkable crew at O’Reilly & Associates, led by our good friend, Deborah Russell, to transform our many chapters and code examples into a book worthy of the O’Reilly imprint. Many thanks to Emily Quill, production manager for the book; Rob Romano, who created the excellent figures; Julie Flanagan, able editorial assistant who helped throughout the project; and the rest of the crew.

And here are the many people we thanked (and continue to be grateful to) for their contributions to the first and second editions of this book:

Jennifer Blair, Eric Camplin, Joe Celko, Avery Cohen, Thomas Dunbar, R. James Forsythe, Mike Gangler, Gabriel Hoffman, Karen Peiser, Pete Schaffer, David Thompson, Cailein Barclay, Sunil Bhargava, Boris Burshteyn, Gray Clossman, Radhakrishna Hari, James Mallory, Nimesh Mehta, Jeff Muller, Dave Posner, Chris Racicot, Peter Vasterd, Zona Walcott, Sohaib Abassi, Per Brondum, Ivan Chong, Bill Dwight, Steve Ehrlich, Bushan Fotedar, Ken Jacobs, Nimish Mehta, Steve Muench, Sri Rajan, Mark Richter, Bill Hinman, Tony Ziemba, John Cordell, Beverly Gibson, Mike Sierra, Gigi Estabrook, Edie Freedman, Donna Woonteiler, Chris Reilley, Michelle Willey, Debby Cunha, Michael Deutsch, John Files, Juliette Muellner, Cory Willing, Seth Maislin, Kismet McDonough Chan, Clairemarie Fisher O’Leary, Eric Givler, Bert Scalzo, John Beresniewicz, Tom White, Steve Hilker, Thomas Kurian, Radhakrishna Hari, Shirish Puranik, Kannan Muthukkaruppan, Jane Ellin, Kimo Carter, Madeleine Newell, Rob Romano, Nancy Priest, Seth Maislin, Fred Polizo, Donald Herkimer, Ervan Darnell, Gary Cernosek, Patrick Pribyl, Bill Watkins, Debra Luik, and Leo Lok.

Finally, Steven thanks his wife, Veva Silva, and two sons, Chris Silva and Eli Feuerstein, for their support and tolerance of so much of his time and attention.

And Bill extends his most heartfelt gratitude to his immediate family, for putting up with writing into the wee hours (“Mommy, Daddy fell asleep at the computer again!”) and remaining a constant source of love and good humor.