Oracle PL/SQL Tips and Techniques

by Joseph C. Trezzo, Brad Brown, Rich Niemiec

This text aims to expand the reader's PL/SQL knowledge by using PL/SQL tips and techniques. Designed for the Oracle developer and database administrator, the book highlights many solutions that are... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0078824389
• ISBN13: 9780078824388
• Release Date: September 1999
• Publisher: McGraw-Hill/Osborne Media
• Length: 942 Pages
• Weight: 4.21 lbs.
• Dimensions: 2.4" x 7.4" x 9.1"

Customer Reviews

Exceptional reference and development aid

I had been developing in PL/SQL for over four years before I got my hands on a copy of this book. This has since provided me with so many useful hints and techniques that have begun to use to great effect in my applications. I would recommend this book to anyone whether they are beginning in PL/SQL or are an accomplished PL/SQL developer.

Great Examples for Fast Reference

Every time I want to try something somewhat obscure and don't want to dig through the Oracle on-line manuals, I have found a quick, easy-to-read piece of sample code in this book. Excellent choice for the experienced Oracle developer's reference book.

Worth the money!

One of the best books I have bought for Oracle PL/SQL. Well worth the money. I have been a developer for 5 years now. Thank you for the insightful and examples that actually make sense AND work. Very well drafted for a beginner/intermediate level PL/SQL developer. Highly recommend it.

A Culmination of Best Practices and Useful Tips

The book is easily worth the price and is an excellent reference volume. It provides standards for best practices for developers of PL/SQL applications, from naming conventions to commenting the source code. This is something that every Oracle developer and DBA should read and try to apply to their environments. The book covers many of the new features of Oracle8i and provides ample examples. The one complaint I have, and it was echoed by some of my associates, was that their was no disk or CD accompanying the book. The authors refer to the examples by file name but there is no disk or CD to get the files from. Presumedly, the examples are available from the Oracle Press Osborne web site. But a disk should have been included for those users who may not have access to the internet. Aside from this, the book is excellent reading for DBAs and developers and is crammed with information. It includes a history of Oracle and PL/SQL that some may not be aware of, as well as the major features of each version of PL/SQL, from version 1.0 through 8.1. For me it was a brief trip down memory lane, for I cut my teeth on version 1.0 of PL/SQL. The index could be improved a little for better cross referencing, but the coverage of Oracle topics is first rate. As a DBA and developer, I found the book invaluable and it is one of the books that I recommend to clients and associates. (Here's a tip: Tell your associates to get their own copy.) The book is written in a near conversational tone and far from the dry, antiseptic tone of Oracle's own manuals. Maybe Oracle should get the TUSC guys to write their manuals. The books is nothing less than what I have come to expect from the people at TUSC.

Best PL/SQL Book I've Ever Read

This is by far the best PL/SQL book I've ever read. I carry it with me everywhere I go. If you can only get one PL/SQL book, this is the one to get. The book is filled with a ton of wonderful scripts that will make you look like an Ace instantly.