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

by Jeff Smith (Author), Patrick McGrath (Author), Bert Scalzo (Author)
Key Phrases: schema browser, user files, session browser, Procedure Editor, Right Mouse, Explain Plan (more...)

Editorial Reviews

Product Description
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.

About the Author
BERT SCALZO is a product architect for Quest Software. As a member ofthe TOAD development team, he designed many of the features in the TOADDBA module. Scalzo has presented numerous papers on data warehousing andled or served on data warehouse special interest groups at Oracle eventsthroughout the past five years. He has worked for both Oracle Educationand Oracle Consulting, holds several Oracle Masters, a Ph.D. in ComputerScience, an MBA, and several insurance industry designations. Scalzodesigned 7-Eleven's multi-terabyte, star-schema data warehouse. He isauthor of "The TOAD Handbook,"

McGrath is an independent producer and a member of the faculty of the Art Institute of Philadelphia.

Product Details

• Paperback: 128 pages
• Publisher: O'Reilly Media, Inc.; 2 edition (May 31, 2005)
• Language: English
• ISBN-10: 0596009712
• ISBN-13: 978-0596009717
• Product Dimensions: 6.9 x 4.2 x 0.4 inches
• Shipping Weight: 4 ounces (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars See all reviews (10 customer reviews)
• Amazon.com Sales Rank: #126,856 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #39 in	Books > Computers & Internet > Databases > Data Warehousing
  #73 in	Books > Computers & Internet > Databases > Oracle
  #93 in	Books > Computers & Internet > Databases > Database Design

• This item is part of The O'Reilly Pocket Guides Series.

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

5.0 out of 5 stars Great little references to the shortcuts you're looking for, March 2, 2004

By	E. Chapa "echapa" (San Antonio, TX USA) - See all my reviews (REAL NAME)

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

I've used TOAD awhile now and saw there were 2 books coming out on it - this on and the TOAD handbook. This little reference is excellent. Great that it just happened to be written on the version I'm using now - 7.4. The book however is based on TOAD's core functionality and not really so much on new features. Just skimming through I came across some features I hadn't even used.

It's does touch on the optional add-ins you can get for TOAD (if you get the commericial version) like the DBA module. It had plenty for me on the debugger. If you're looking for a tutorial, this isn't it, though it does remind you about looking in the docs folder for TOAD documentation in PDF. This little guide is a great reference.

7 of 7 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 500 REVIEWER)

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