JCC Seminar Description

This seminar focuses on issues that are common to any GUI interface to any database. It covers, for example, transaction control and other performance basics, as well as discussing the network and what happens where for best results.

The seminar also covers specifics of Oracle Developer, particularly Forms, and of using Oracle Rdb with the Oracle tools. The seminar details both capabilities and issues.

The seminar is not merely a primer in how to use the tools. In addition there are significant sections, based on JCC practical experience, that are not available in the standard training at either the introductory or advanced levels. These practical pointers, together with the source code examples, will help you build robust applications for solutions to real business problems. You will learn when to accept Oracle Developer defaults, when and how to modify the defaults, and when to add procedural components.

The developers and presenters of this seminar have long term experience with software development. You will be able to share the results of experience with the products as well as a wide variety of application successes and significant experience in software research.

Students will have hands-on use of the product to access Oracle Rdb.

Basics

• Client/server & multi-tier architectures
• Overview of creating a form with Oracle Developer interspersed with labs
• A User View - What Oracle Developer has done for you
• Installation and Relationship of the software components

Managing It All

• Software Engineering challenges
• Managing your production database
• Examining the queries that Forms presents to the database
• Standards
• Object libraries

Upward Compatibility

• Defaults versus customization
• Version conversion
• Issues for a smooth path
• Documentation and HELP

Programming Issues

• PL/SQL
• Built-in procedures
• Transaction control
• Calling stored procedures and Rdb functions
• Leveraging Rdb’s system tables

More on Forms

• Lists
• Scroll bars
• Types of canvases and their interaction
• Types of items - buttons, text, checkboxes, etc.
• LoV and Validation
• Blocks and block relationships
• Forms triggers
• Toolbars
• Menus
• More on standards
• Debugging

Navigation

• Event-driven programming
• Using and/or suppressing Oracle Developer’s helpful procedures
• Multi-form applications

Linking to Other Software

• Icons
• Images
• APIs
• Web delivery
• Other Oracle products

Oracle Reports

• Creating
• Using
• Calling Rdb stored procedures/functions
• Transaction control
• Integration with Forms

Webforms

• Performance issues
• Forms6i CGI