Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly)) [Paperback]

Jeff Smith (Author), Patrick McGrath (Author), Bert Scalzo PH.D. (Author)

Book Description

Publication Date: June 1, 2005 | Series: Pocket Reference (O'Reilly)

Toad is an enormously popular interactive environment tool for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. Toad makes developers far more productive; using Toad, you'll find that program changes that once took hours can now be completed in minutes. Toad allows developers to browse their database tables, procedures, and object types; use code templates; and show errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics.

Updated for Toad Versions 8.0 and 8.5, this pocket book is packed with quick-reference material: Toad feature and menu summaries, shortcut keys, suggested changes to Toad defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic Toad components: the SQL Editor, Procedure Editor, SQL Modeler, Schema Browser, Project Manager, and Debugger. The second edition includes coverage of new SQL Editor features, improvements in usability, and new tools such as CodeXpert (a robust code analyzer and advisor) and Script Debugger (the only tool available that provides real-time debugging of SQL*Plus scripts). It also provides helpful hints on using Toad to perform database administration and SQL tuning and optimization.

Whether you're a new or experienced Toad user, you'll find this quick reference an indispensable companion to the product and its online help files.

Editorial Reviews

About the Author

Jeff Smith is a Solutions Architect at Quest Software. What does that mean exactly? He gets paid to talk about Toad and the other database products at Quest. He has been with Quest since 2001, working on the Toad R&D, Product Management, and Sales organizations. Jeff is the primary author of the Toad Handbook, 2nd Edition, published by O'Reilly and is currently working with Bert and Patrick on the next edition! He holds a bachelor's degree in Computer Science from West Virginia University. Jeff is a regular speaker at Toad User Groups and Oracle User Groups worldwide. While not travelling to exotic locales like Melbourne, Australia or Peoria, Illinois, Jeff attempts to keep up with the Toad developers mountain-biking around Raleigh, NC.

Patrick McGrath is a technical marketing representative at Quest Software.

Bert Scalzo is a Quest software developer and well-known author in the Oracle/SQL world.

Product Details

• Paperback: 128 pages
• Publisher: O'Reilly Media; Second Edition edition (June 1, 2005)
• Language: English
• ISBN-10: 0596009712
• ISBN-13: 978-0596009717
• Product Dimensions: 7 x 4.4 x 0.3 inches
• Shipping Weight: 4 ounces (View shipping rates and policies)
• Average Customer Review: 4.3 out of 5 stars  See all reviews (12 customer reviews)
• Amazon Best Sellers Rank: #126,337 in Books (See Top 100 in Books)
  • #19 in Books > 4-for-3 Books > Computers & Internet > General
  • #37 in Books > Computers & Technology > Databases > Data Warehousing

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

4.0 out of 5 stars Toad that was a Prince, March 10, 2006

By 

C. A. Luster "The Rook" (Burke, VA USA) - See all my reviews
(TOP 1000 REVIEWER)   

Amazon Verified Purchase

This review is from: Toad Pocket Reference for Oracle (Pocket Reference (O'Reilly)) (Paperback)

As in most of the O'Reilly pocket paperbacks, this one is a wonderful resource. If you need a quick check of something you don't recall the details, this will probably assist you admirably. It requires you be knowleable of Toad. If you are looking for something to instruct you in the use of Toad, you may want a more substancial book. This one includes some tips and tricks that should prove beneficial to most experienced Toad users. As a quick reference the layout is good and the table of contents makes it easy to find what you need. There is not alot of meat on these bones, but the meat is pretty good. For more in depth explainations you may want to look at the Toad Handbook by Bert Scalzo and Dan Hotka.

9 of 10 people found the following review helpful:

5.0 out of 5 stars Dedication To Oracle Administration or Developer, December 13, 2002

By 

Anthony Lai Cheuk Tung "Anthony LAI, CISSP, C... (Hong Kong SAR) - See all my reviews

This review is from: TOAD Pocket Reference for Oracle (Paperback)

In my past few years, I am working as a developer for an e-Banking System, I have an opportunity to know Oracle, however, I would like to know more about it, apart from reading books or being certified, the best way is to "Practise", there is an experienced DBAs told me you can use a tool called "TOAD" for your reference, you will be much faster to be on tract and see what's going on in Oracle, it helps during load test and development time. Also, it is a tool for Oracle developer, some of my friends test their program in Oracle, but it is not a good practice and TOAD provides a good way for us to defend our standard and practice.

Actually, why do you need this book ? Why don't you just download the documentation or print out the manual from [the website]?

The reason is simple: This book is precise and direct.
This book likes provides clear steps for you to achieve various functions including administration, debugging , SQL and Procedures.

If you find, there are two books called Unix For Oracle and Oracle DBA Checklists, those are simple and crucial steps required by DBA as well as manager, we don't need a thick book with 800 pages, we just need a book with 100 pages and portable.

I strongly recommend this book for consultants and developers.

It helps me to solve problems many times...:>

Anthony

7 of 8 people found the following review helpful:

4.0 out of 5 stars Boy I did not know that TOAD can do so much, September 12, 2002

By 

Gregor Theis (Meerbusch Deutschland) - See all my reviews
(REAL NAME)   

This review is from: TOAD Pocket Reference for Oracle (Paperback)

I used TOAD during my work every now and than. I especially liked the Schema Brower. In this book I learned about the other features of TOAD that I did not use before. I will probably start to use some of these features in the future.

I like books that teach me new things and help me be more productive in my work. This is definitely one of those book.

It might be unfair that I only give 4 stars but I would have liked this book to be longer and with some examples. This is of course not possible in a pocket reference.

I can really recommend this book to the normal TOAD user. Maybe this is superfluous for the advanced TOAD user.