Oracle Designer Generation

Overview

Take full advantage of Oracle Designer's ability to generate high-quality,Oracle Developer application systems.

Create quality,highly generated systems with Oracle Designer.

Take full advantage of Oracle Designer's ability to generate high-quality,Oracle Developer application systems. One of Oracle Designer's greatest strengths is its code-generation capabilities. Oracle Designer Generation details how to design and build modules that maximize ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (25) from $1.99   
  • New (1) from $60.00   
  • Used (24) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$60.00
Seller since 2014

Feedback rating:

(136)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

Take full advantage of Oracle Designer's ability to generate high-quality,Oracle Developer application systems.

Create quality,highly generated systems with Oracle Designer.

Take full advantage of Oracle Designer's ability to generate high-quality,Oracle Developer application systems. One of Oracle Designer's greatest strengths is its code-generation capabilities. Oracle Designer Generation details how to design and build modules that maximize the use of the Forms,Reports,Servers and MS Help generators. Following detailed,step-by-step examples,you will increase your productivity and improve the quality of your Oracle Developer application systems.

You will learn to:

  • Generate server-side application logic,including procedures,functions,packages,database triggers,and the Table API
  • Generate standard form features,including windows,canvases,blocks,text items,checkboxes,radio groups,pop lists,image items,buttons,and tab canvases
  • Control the layout and functionality of your generated forms
  • Use templates,object libraries,and preferences to implement your standards and generate specialized forms: LOV forms,splash screens,wizards,and menus
  • Generate and integrate an MS Help or Forms-based help system
  • Generate basic reports as well as sophisticated reports using user parameters,unbound items,format triggers,report-level triggers,and complex SQL
  • Generate standard report layout styles,including tabular,form,address/mailing label,control break,and master detail and matrix styles

To get the most out of Oracle Designer's generators during the build phase of your project,look to the only officially Oracle-authorized bookfor all the details you need: Oracle Designer Generation.

Read More Show Less

Product Details

  • ISBN-13: 9780078824753
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 5/3/1999
  • Series: Oracle Press Series
  • Edition description: Book and CD ROM
  • Pages: 1154
  • Product dimensions: 7.38 (w) x 9.08 (h) x 2.51 (d)

Read an Excerpt

Chapter 3: Seven Keys to Successful System Generation

In the years we have been using Oracle Designer to generate Oracle Developer systems, we have learned that there are a few obstacles that can really hinder your development effort, but there are also some great opportunities to prepare the way for a very successful system development effort. We have organized some of our experience into a series of important areas that you need to consider, which we call "The Seven Keys to Successful System Generation." They are:
  • Key 1: Management Support
  • Key 2: Experienced Mentoring and/or Training
  • Key 3: Infrastructure
  • Key 4: Standards
  • Key 5: Realistic Expectations
  • Key 6: Designing for Generation
  • Key 7: User Involvement
A perfect situation in every one of these areas is not needed to successfully generate a system, but they are all areas that you should consider as you try to improve your system development process. As you read about these keys, think about how your development organization approaches each of these areas. You may find areas in which you can improve the environment and therefore improve the chances that your system is developed successfully. You may also find problem areas that you cannot address at this time, but understanding your organization's weaknesses in each of these areas will help you reduce their impact on your development.

(1)Key 1: Management Support

So you're convinced that Oracle Designer is the way to go. You want to develop quality systems and do good analysis before you start to build the application. You're convinced you can generate most of your application. It's time to talk to your managerabout using the tool. "How much does the tool cost?" he asks. When you tell him, he exclaims, "But we've already spent all of that money for the other Oracle tools!" (strike 1). Next, you tell him that it is not easy to learn, and he will have to send all of his developers to at least two weeks of training. "I'm sorry, we don't have enough money in the training budget" (strike 2). Then you tell him that you will have to change the whole way you perform development to take advantage of the tool. "We've always done it this way, and it has worked so far! Who are you to tell me how to do system development!" (strike 3, you're out!). There are also user interface limitations that might concern your management. While these concerns can be addressed easily, this is often the initial response to the suggestion of using Oracle Designer.

If yours is the lone voice (or one of a few) in your organization that is convinced that using Oracle Designer to generate your system is the way to go, you may have your work cut out for you. It usually takes some changes in the way your organization develops systems in order to use the Designer tool correctly, and this is very difficult to do without management support.

For instance, you will have to have support to justify the increased software and training cost of using Oracle Designer. It's the management's budget that will be impacted, and they will have to be convinced if they are to defend the request.

In addition, quite often, your development process will have to change significantly. For example, you will probably need more information earlier in the development process than you are used to. You will have to prevent developers from hacking the generated code instead of learning how to use the generators to the fullest capacity. It can be very difficult to get all of the developers to do this if the management is not supportive.

There are sometimes limitations to what you can generate with Oracle Designer. It is much better to accept the limitations and design your system to fit within them. However, quite often your customers will want to do something that you cannot generate but that is not really critical to the system. Your system will be more successful if your management supports the idea of near 100 percent generation. If your management is unwilling to hold a hard line on this, you may find yourself doing a lot of post-generation modifications, which can reduce the value of many of the benefits of using the generators. With release 2, the limitations are fewer than with release 1.3, but some limitations remain.

If your management is not already convinced that you should be using Oracle Designer, you will need to arm yourself with as many arguments as you can to convince them that using Oracle Designer is in your organization's best interest. You can use some of the advantages we detailed in Chapter 2 to help you come up with these arguments. There are also many people in the Oracle development community who have had great success using Oracle Designer and who will give you information that will help you justify using the tool. Ask these people to share their experiences with you. You can talk to these people at users group meetings or post questions in Oracle Designer e-mail lists.

NOTE: The Oracle Development Tools User Group (ODTUG) e-mail lists are a great source for help in justifying the use of Oracle Designer. Many people who participate in the list will answer your specific questions as well as share their success (or failure) stories. These e-mail lists are also a great source for help with using the Oracle development tools. For information about becoming a member of ODTUG, check out their Web site at www.odtug.com.
(1)Key 2: Experienced Mentoring and/or Training

Oracle Designer is a complicated tool. It is very difficult to use it without some sort of training or experienced mentoring. Usually, it is better to get both training and mentoring, but try to get at least one or the other.

(2)Training

To get the development staff up to speed with Oracle Designer, everyone will need some training! It is possible to learn how to use the tool without specific classroom training (by using the tutorial or trial and error), but this is not the best way to get your staff quickly up to speed. Someone who learns how to use the tool without classroom training may not understand the whole process, and this can lead to a less efficient use of the tool. There are many ways to perform most of the development tasks using Oracle Designer, and the first way that someone figures out how to perform a particular task may not be the best way. You can learn many techniques and tricks in a class that are hard to figure out on your own.

The development staff should begin their Oracle Designer training as close as possible to the time when they are going to start using the tool (this is called just-in-time (JIT) training). If the staff is trained six months before they use the system, they will probably forget much of what they learned and will have to learn it all over again when they are ready to use it. On the other hand, getting the training after they have almost finished the development does not help very much either (we have seen this happen!).

If a development organization is large enough, the easiest way to get JIT training is to schedule on-site classes when they are needed. Oracle Education, many training/consulting companies (like the one we work for), and many independent consultants are available to come to your organization's site to do the training whenever it is needed. If an on-site class is out of the question, try to get the off-site training for the developers scheduled as close as possible to the time of the actual development. (2)Experienced Mentoring

Oracle Designer is a very complicated tool. There are many ramifications to decisions made about administration, design, standards, etc., that cannot be understood without some experience. Because of this, it is very important to get help with the first Oracle Designer project. An experienced Oracle Designer consultant can steer developers around some of the pitfalls and help the development team get up to speed on the tool much more quickly than they could otherwise.

An experienced consultant can do the following:

  • Help you to gain management support for using Oracle Designer based on real world success and failure experiences. (Key 1).
  • Set up the environment and infrastructure to support Oracle Designer development (Key 3).
  • Help you develop and enforce standards (Key 4).
  • Set realistic expectations based on their previous experience (Key 5).
  • Help you design the system so that it can be easily generated (Key 6).
  • Give specific help for the problems that are encountered during development.
As you can see, an experienced consultant can help you successfully implement many of the other keys to successful generation. Because of this, we feel that getting a consultant to help you with your first project is probably the best thing you can do to be successful. However, the consultant should not be a permanent member of your staff. You should find a consultant who is a good mentor, someone who will train your staff adequately so you don't have to always rely on the consultant. Once an organization has a few Oracle Designer projects under its belt, a level of internal expertise should be developed that can be relied upon for future projects, and an outside consultant will no longer be needed.

(1)Key 3: Infrastructure

The environment needed to support Oracle Designer is not a simple one. There are many complex management, environment, and infrastructure issues that need to be addressed correctly in order to generate systems successfully. The stability and robustness of the generation infrastructure is a factor that quite often separates successful system development efforts from unsuccessful ones. We will consider three major areas of infrastructure that need to be addressed:

  • Repository installation and management
  • Development environment
  • Object libraries, templates, and template architecture
There are many separate but interrelated issues within each of these areas that need to be considered. They will be covered in the following sections.

(2)Repository Installation and Management

Without a repository, you cannot use Oracle Designer at all! This may seem obvious, but quite often not enough emphasis is placed on making sure that the Oracle Designer repository is installed and managed correctly. An incorrectly managed repository can lead to performance problems with the tool, which can drastically reduce the efficiency of your developers. It can also lead to loss of data, which at best means that some development work will have to be redone; at worst it can introduce defects into your system. Your repository might become unavailable for a few days, which could have a major impact on your development schedule.

(3)The Repository Should Be Considered a Production Installation

There is quite often a big difference between a development installation and a production installation of an Oracle instance. In a production instance, more care is taken to make sure that there are good regular backups. Usually the production instance will use archive logging or mirroring (or both) to ensure that there is no loss of data if there is a disk failure. The DBAs will monitor the instance more carefully, performing proactive maintenance on the instance to keep the performance acceptable and to ensure that the instance does not go down. This is not always the case for a development instance. You should always consider the Oracle Designer repository instance as a production instance! It is running the production version of an important application that is used by many people. Quite often, your organization will lose as much money if it goes down as they would with many of the end-user production systems. Even if the rest of your environment is treated as a development environment with lower maintenance standards, you should make sure that the Oracle Designer repository instance is treated like a production instance.

As a production instance, the following should be in place:

1. The repository should be installed in an instance easily available to everyone on your development team. The connectivity between the server with the instance and the client machines that will use the tool should be stable.

2. There should be a regular backup of the repository. This can be done by having a regular backup of the whole instance or a backup of just the repository using the tools provided in Oracle Designer.

3. If possible, archive logging should be turned on, or the instance should be mirrored (either one or the other or both, at your DBA's discretion). This will prevent any loss of data in the case of a disk failure.

4. The DBA should monitor the instance for fragmentation and defragment the instance if it needs it.

(3)Have an Experienced DBA

An experienced DBA should create the instance and install the repository. While most experienced Oracle developers can install the repository; they may not know enough about your organization's infrastructure to do the best installation possible. Oracle Designer allows you to split the repository up into multiple tablespaces according to how the tables in the repository are to be used. An experienced DBA will know how best to use this feature to improve the performance of the tool. They will also make sure that the instance and repository is set up in such a way that it can be easily recoverable in the event of a hardware failure or corruption of the repository...

Read More Show Less

Table of Contents

Acknowledgements.

Introduction.

Part I: System Generation with Oracle Designer.

Overview of the System Generation Process.

The GOAL - Highly Generated Systems.

Seven Keys to Successful System Generation.

Part II: Server-Side Code Generation.

PL/SQL Definition Method.

Generating Procedures.

Generating Functions.

Generating Packages.

Generating Triggers.

Generating the Table API.

Part III: Forms Generation.

Overview of Forms Generation.

Before You Create the Modules.

Window, Canvas, Block, and Item Generation.

GUI Item Generation.

Item Navigation Functionality.

Unbound Item and Lookup Item Functionality.

Error-Handling Functionality.

Other Standard Functionality.

Item Validation an LOV Generation.

Layout Generation Techniques.

A Layout Generation Cookbook.

Navigation Module Generation.

Part IV: Forms Generation Infrastructure.

Using Templates and Object Libraries.

Application Logic and Code Reuse.

Help Generation.

Deployment Options.

(and more...)

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)