Oracle PL/SQL by Example

by Anderson, Carrie; Wendelken, David

• ISBN13: 9780201634457
• ISBN10: 0201634457
• Edition: 1st
• Format: Paperback
• Copyright: 1996-11-13
• Publisher: Addison-Wesley Professional

Summary

if you are working with Designer/2000, Oracle's powerful set of tools for information systems design and generation, this book will serve as your indispensable guide. Not only does it provide detailed and understandable documentation for every component of Designer/2000, it also shows how and when each of these tools comes into play in the context of the information systems development life-cycle. You will learn how these tools operate, how they should be used, and most importantly, how to adapt the information systems development process to take full advantage of their capabilities. The book includes documentation for all of Designer/2000's strategy, analysis, design, and code building tools, including the Process Modeller, the Entity-Relationship Diagrammer, the Database Design Wizard, the Data Diagrammer, the Application Design Wizard, the DDL Generator, and much more.

Author Biography

David Wendelken is a Senior Consultant for Tactics, Inc.

Table of Contents

The Oracle® Designer/2000 Handbook includes

documentation for all of Designer/2000's strategy, analysis, design, and code-building tools, including the Process Modeller, the Entity-Relationship Diagrammer, the Database Design Wizard, the Data Diagrammer, the Application Design Wizard, the DDL Generator, and much more

an overview of the development process, with a work flow road map detailing the specific steps to take when building an application with Designer/2000

information on designing and generating forms and reports, including use of the Module Data Diagrammer, templates, and User Preferences

advice on how to customize the Designer/2000 toolset to improve your productivity

an explanation of how to capture existing applications with Designer/2000

As you discover the purpose and significance of each Designer/2000 tool, you will gain invaluable insight into the software development process and how you can use Designer/2000 to create systems that better serve your clients. 0201634457B04062001

Table of Contents provided by Publisher. All Rights Reserved.

Excerpts

To our colleaguesThis is the traditional place where authors explain what prompted them to write, as well as acknowledge those who helped with, or patiently endured, the writing of the book. It is traditional to bury at least one trenchant observation in this otherwise expendable prose so that the perceptive reader will at least skim through the passage. Allow us to be slaves to tradition in this one matter!We could explain that we wrote this to promote a better understanding of Designer/2000, hoping to provide useful and pragmatic assistance to our professional colleagues in their daily work; and for students learning Designer/2000 as part of their curriculum. That would certainly be true, but not the whole truth.One person mentioned that they couldn't write such a book, for they didn't know the tool well enough to do so. Our response? That we didn't either, but we expected to by the time we had finished writing! This was a learning opportunity for all involved, and not just limited to Designer/2000.Perhaps the most important lesson was that a book of about five hundred pages is not the same amount of work as twenty papers twenty-five pages long. It is much more effort, by several orders of magnitude! Why this surprised us is a mystery; for we've long known that a five-hundred-entity application is far more difficult than twenty applications with twenty-five entities each.That problem is the root of many software development failures. Many project leaders cut their teeth on small projects. They wonder why those who are working on larger projects are soooo slow and so bureaucratic. They often get their opportunity to work on large projects because of their successful track record on previous, smaller projects. Many of the techniques that they use to be successful on smaller projects do not scale up, just as some hardware/software solutions do not. Unfortunately, neither limitation is usually discovered until the appropriate level of stress is placed upon the system!We have attempted to provide some guidance on proper usage as well as the reasoning behind the guidelines, hopefully in an entertaining manner. We hope that the reader will learn and follow the software development processes that underlie all good tools like Designer/2000. We have included a small list of suggested readings at the end of this book. All are worth reading, so have at them and enjoy!0201634457P04062001