The first edition of Oracle PL/SQL Programming quickly became an indispensable reference for both novice and experienced PL/SQL developers. Packed with examples and recommendations, it helped everyone using PL/SQL (from the Oracle Forms developer to the database administrator) make the most of this powerful language. Oracle8 presents PL/SQL programmers with new challenges by increasing both the possibilities and complexities of the language. This new edition updates the original book for Oracle8, adding chapters describing the new PL/SQL object features (object types, collections, object views, and external procedures). The second edition also contains a much-requested chapter on tuning PL/SQL, as well as expanded discussions of debugging and tracing PL/SQL execution. The book comes with a companion diskette containing the Companion Utilities Guide for Oracle PL/SQL Programming, an online tool developed by RevealNet, Inc. The online guide contains more than 100 file of source code and documentation prepared by the authors. Even if you've already read the first edition of Oracle PL/SQL Programming, you'll find an enormous amount of new and revised information in this second edition and on its companion diskette. If you're new to PL/SQL, you'll soon find yourself on the road to mastery. NOTE: To make room for the new material, some summaries and code from the first edition have been moved to the companion disk. Oracle PL/SQL Programming is divided into seven parts: Foreword Preface Part I: Programming in PL/SQL

• 1. Introduction to PL/SQL
• 2. PL/SQL Language Fundamentals
• 3. Effective Coding Style

Part II: PL/SQL Language Elements

4. Variables and Program Data

5. Conditional and Sequential Control

6. Database Interaction and Cursors

7. Loops

8. Exception Handlers

9. Records in PL/SQL

10.PL/SQL Tables

Part III: Built-in Functions and Packages

• 11. Character Functions
• 12. Date Functions
• 13. Numeric, LOB, and Miscellaneous Functions
• 14. Conversion Functions

Part IV: Modular Code

• 15. Procedures and Functions
• 16. Packages
• 17. Calling Stored PL/SQL Functions from SQL

Part V: PL/SQL Oracle8 Features

• 18. Object Types
• 19. Nested Tables and VARRAYs
• 20. Object Views
• 21. External Procedures

Part VI: Making PL/SQL Programs Work

• 22. Code Design Tips
• 23. Managing Code in the Database
• 24. Debugging PL/SQL
• 25. Tracing PL/SQL
• 26. Tuning PL/SQL

Part VII: Appendixes

• A. What's on the Companion Disk?
• B. Calling Stored Procedures from PL/SQL Version 1.1
• C. Built-in Packages

Rating:

Rating:

Rating:

Oracle PL/SQL Programming, 2nd Edition Review,  June 01 2001
Submitted by Saiful Alam   [Respond | View]

It is an EXCELLENT BOOK!

For anyone trying to learn PL/SQL this book is the best one I've seen!

I recommend it for all developers of PL/SQL applications.




Oracle PL/SQL Programming, 2nd Edition Review,  November 22 2000
Submitted by Tom Henricksen   [Respond | View]

I am new to Oracle Deveoplement. This book was suggested by one of my co-workers. I have read through a few Oracle books but this one is far superior than anything they have put out. Steve is a great writer and makes a dry subject readable.




Oracle PL/SQL Programming, 2nd Edition Review,  October 19 2000
Submitted by Stephan   [Respond | View]

EXCELLENT BOOK! Combined with a PL/SQL Debugger like SQL-Programmer from SFI, this book rocks! Buy it now, you need it.




Oracle PL/SQL Programming, 2nd Edition Review,  April 11 2000
Submitted by Kevin M Lanaghan   [Respond | View]



The best PL\SQL Book I've seen.


Oracle PL/SQL Programming, 2nd Edition Review,  February 16 2000
Submitted by Robin   [Respond | View]



I recommend this book highly to every developer I work with, and to every class that I teach. This is the definitive reference for PL/SQL, a dog-eared, constantly used reference for beginners and advanced programmers alike. Several other books try to cover the PL/SQL language, but none have the detail level, comprehensive discussions, and examples of this book.

Normally, I do not buy "2nd" edition releases, since they add little to the original -- this book is an improvement on the first. With the other PL/SQL books from O'Reilly (Programmning with Packages and Oracle Built-ins) this is a complete reference shelf for Oracle developers.


Oracle PL/SQL Programming, 2nd Edition Review,  December 03 1999
Submitted by Andrew Smith   [Respond | View]



I have been programming in PL/SQL for a number of years now, and still find useful nuggets of information in this book. I recommend it for all developers of PL/SQL applications.


Oracle PL/SQL Programming, 2nd Edition Review,  October 04 1999
Submitted by Mike   [Respond | View]



Excellent book. It covers both the forest view of PL/SQL and the individual trees. It is very good at organizing and presenting an ad-hoc like language into something that is highly structured and ordered. Also contains very good insight on how to debug/ finetune PL/SQL code. I highly recommend it. ----------


Oracle PL/SQL Programming, 2nd Edition Review,  September 30 1999
Submitted by Warren S. Corman   [Respond | View]



Although I have had some exposure to the PL/SQL environment I was somewhat overwhelmed until I dove into this book. For anyone trying to learn about the wonderful world of PL/SQL this book is the one!


Oracle PL/SQL Programming, 2nd Edition Review,  May 27 1999
Submitted by James Todd   [Respond | View]



I'm a fairly new developer of PL/SQL and this book has been an invaluable resource. If you only buy one book, make this the one.


Oracle PL/SQL Programming, 2nd Edition Review,  March 18 1999
Submitted by Stephanie Giovannini   [Respond | View]



I have to admit that I haven't read the whole book yet. In fact, I've only read the first four chapters. But I'm so impressed with the first four chapters that I figure I've already got my money's worth. I like to read a book cover to cover, every word. Many computer books are written in such a dry, choppy style that this is impossible. This book is a pleasure. I enjoy the humor, the real-life anecdotes and, of course, there's lots of technical stuff. What I like most about the book are the coding standards and "best practices" that appear throughout the book (well, at least the first four chapters). Most of the technical content of this book is contained in the Oracle on-line books--but without this extra insight and commentary the technical details just don't mean much. This book answers the "how do I use this?" and "why do I care?" questions. If you're doing PL/SQL, this is THE book to have.

See larger cover