Customer Reviews

Oracle8 Pl/SQL Black Book

5 star:		(5)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

This is the best book I have come across during my pursuing PL/SQL. Its style of gradually building up of the various concept makes it an intersting reading of an otherwise quite boaring subject. I wish to make a suggestion to enhance the value addition from the book. It would be a great help if the tables used in the examples are also provided with the book so that the reader can actually write the codes and see the results for himself rather than trying to visualise the outcome.

This book is very well structured and easy to learn from. The content is easy to read, good examples and very referenceable.

I highly recommend this book. The only issue is its availability, I find it hard to believe that the publishers have not cashed in on this book (did n't republish - currently out of print) as it is a real winner and a gem to have.

Listed below are the chapters.

1. PL/SQL At A Glance
2. Writing Simple Routines
3. Program Flow Control
4. Accessing the Database
5. Complex Datatypes
6. Creating Programs
7. Using Object Types
8. PL/SQL In Different Environments
9. PL/SQL And Application Performance
10. PL/SQL Fundamentals
11. Blocks, Stored Programs, Packages, Database Triggers And Stored Types
12. Declarations
13. Procedural Constructs
14. Built In Functions
15. Oracle 8 Supplied Packages
16. Extended SQL And PL/SQL Support
17. External File I/O And Background Job Control
18. Support of LOB Datatypes
19. Event Notification And Intersession Communication Support
20. Advanced Queuing Support
21. Miscellaneous Packages

This book takes you through some really great examples and includes everything you need to know about PL/SQL. I use it as a reference all day long when writing my code.

Book contained excellent examples; I have read several PL/SQL books and found this one very insightful especially for developers. You will be able to tell that the authors are bonafide developers relating real experiences; they not only explain the technical issues but how they applied in the real-world applications - highly recommended for serious developers.

This book is a great guide to PL/SQL, especially for DBA's and non-programmers. The reference section is especially good, and I can quickly find PL/SQL snippets to assist me.