Oracle PL/SQL Tips and Techniques [Paperback]

Joseph Trezzo (Author), Brad Brown (Author), Rich Niemiec (Author)

Book Description

Series: Oracle Series | Publication Date: September 6, 1999

This book teaches readers how to master the ins-&-outs of Oracle's database programming language - including new Oracle8 object-relational extensions. "PL/SQL" is the fastest selling area of interest within the Oracle developer community.

Editorial Reviews

From the Back Cover

Expert technical knowledge at the turn of a page.

Expand your PL/SQL knowledge to the next level by using hundreds of PL/SQL tips and techniques provided in this one-of-a-kind reference, designed for every Oracle developer and database administrator. This book highlights many solutions that are either hidden, undocumented, or can only be discovered through many years of experience or through laborious trial and error.

In Oracle PL/SQL Tips & Techniques, you will find hundreds of real-world examples, scripts, and insider secrets compiled from TUSC's standing-room-only conference presentations and Oracle User Groups worldwide. This invaluable PL/SQL arsenal can be deployed in your environment to catapult your current Oracle and PL/SQL knowledge to the next level when you learn the following:

• PL/SQL Development Foundation
• PL/SQL Coding Standards
• PL/SQL Coding Techniques
• PL/SQL Program Unit Coding Techniques
• SQL and PL/SQL Performance Tuning
• DBA Related PL/SQL Issues
• PL/SQL Security
• Oracle Supplied Packages
• PL/SQL Data Dictionary Scripts
• New PL/SQL Role in Web Applications
• New PL/SQL Related Features (Oracle8 & Oracle8i)
• PL/SQL Quick Reference

About the Author

Joseph C. Trezzo, Bradley D. Brown, and Richard J. Niemiec are co-founders of TUSC (The Ultimate Software Consultants), an award-winning, senior-level RDBMS consulting company specializing in Oracle. Trezzo has served as Editor-In-Chief and Brown Executive Editor of the Exploring Oracle DBMS magazine. Niemiec is the Executive Vice-President of IOUG and Executive Editor of IOUG-A's Select magazine. These three are the driving force behind TUSC's success--their efforts were most recently recognized by their induction into the Entrepreneur Hall of Fame.

Product Details

• Paperback: 942 pages
• Publisher: Osborne/McGraw-Hill (September 6, 1999)
• Language: English
• ISBN-10: 0078824389
• ISBN-13: 978-0078824388
• Product Dimensions: 9.1 x 7.4 x 2.4 inches
• Shipping Weight: 4.2 pounds
• Average Customer Review: 4.4 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #2,285,954 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

4.0 out of 5 stars One of the Best, January 12, 2000

By 

Albert - See all my reviews

This review is from: Oracle PL/SQL Tips and Techniques (Paperback)

The book is indeed worth the money (if your boss is paying :). I have never seen so many PL/SQL techniques and close-to-real-life examples before. I was starting a new project involving extensive PL/SQL programming, and although I had 3-year experience, I've found myself working with the book on my keyboard. There are some quite important tips I could never suggest - e.g. like sysdate usage. But of course there are some questions that the book doesn't anwser, for example how to implement error log that survives a rolback. The book is targeted both for DBA's and developers, a concept is a little bit new for me.

11 of 11 people found the following review helpful:

5.0 out of 5 stars A Culmination of Best Practices and Useful Tips, October 10, 2000

By 

Reginald (Houston, TX, United States) - See all my reviews
(REAL NAME)   

This review is from: Oracle PL/SQL Tips and Techniques (Paperback)

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.

7 of 7 people found the following review helpful:

4.0 out of 5 stars A good book to have handy, October 21, 1999

By A Customer

This review is from: Oracle PL/SQL Tips and Techniques (Paperback)

I picked up this book a few weeks ago and so far so good. It has a great deal of USEFULL practical examples. Time will tell if it is really the best reference out there, but I have learned a great deal from it already.