| |
| |
| Introduction | |
| |
| |
| |
| Oracle Developer | |
| |
| |
| |
| Oracle Forms and Reports--Overview and Architecture | |
| |
| |
| History of Oracle's Development Tools | |
| |
| |
| Before the Days of Graphical User Interfaces | |
| |
| |
| Client/Server Computing | |
| |
| |
| The Birth of Web-Based Applications | |
| |
| |
| Advantages of Client/Server over Web-Based Applications | |
| |
| |
| Components of the Oracle Internet Developer Suite | |
| |
| |
| Oracle Designer and Repository | |
| |
| |
| Oracle Forms Developer | |
| |
| |
| Oracle Reports Developer | |
| |
| |
| Oracle JDeveloper | |
| |
| |
| Oracle Discoverer | |
| |
| |
| Oracle Portal | |
| |
| |
| Oracle Forms Developer | |
| |
| |
| Forms Compiler and Forms Runtime | |
| |
| |
| Oracle Forms Server | |
| |
| |
| Oracle Reports Developer | |
| |
| |
| Oracle Reports Compiler and Runtime | |
| |
| |
| Oracle Reports Server | |
| |
| |
| Tools Common to Both Forms and Reports | |
| |
| |
| Graphics Builder and Runtime | |
| |
| |
| Query Builder | |
| |
| |
| Schema Builder | |
| |
| |
| Procedure Builder | |
| |
| |
| Project Builder | |
| |
| |
| Translation Builder | |
| |
| |
| The Oracle Database Server's Role in Forms and Reports Development | |
| |
| |
| PL/SQL | |
| |
| |
| Java | |
| |
| |
| Objects | |
| |
| |
| Deployment of Forms and Reports | |
| |
| |
| The Three-Tiered Model | |
| |
| |
| Summary | |
| |
| |
| |
| Developer Basics | |
| |
| |
| Installation | |
| |
| |
| Operating System Requirements | |
| |
| |
| Hardware Requirements | |
| |
| |
| Database Server Requirements | |
| |
| |
| Installation Help for Microsoft Windows | |
| |
| |
| Installation on Unix | |
| |
| |
| Installing the Sample Tables | |
| |
| |
| Using Forms Developer | |
| |
| |
| Building Your First Form | |
| |
| |
| Running Your Form | |
| |
| |
| Building Complex Forms | |
| |
| |
| Using Reports Developer | |
| |
| |
| Creating Your First Report | |
| |
| |
| Building Complex Reports | |
| |
| |
| Using Oracle Graphics | |
| |
| |
| Your First Graph | |
| |
| |
| Complex Charts and Graphs | |
| |
| |
| Summary | |
| |
| |
| |
| Oracle Forms Developer | |
| |
| |
| Creating a Master-Detail Form Using the Forms Builder | |
| |
| |
| Master-Detail Relationships | |
| |
| |
| Starting a Master-Detail Form | |
| |
| |
| The Object Navigator and Property Palette | |
| |
| |
| Adding the Detail Block | |
| |
| |
| Using the Re-Entrant Layout Wizard | |
| |
| |
| Master-Detail Forms in the Runtime Environment | |
| |
| |
| Using the Layout Editor | |
| |
| |
| Moving Objects | |
| |
| |
| The Layout Editor Toolbars | |
| |
| |
| The Layout Editor Visual Tools | |
| |
| |
| The Layout Editor Ruler and Grid | |
| |
| |
| A More Detailed Look at the Object Navigator | |
| |
| |
| Summary | |
| |
| |
| |
| Oracle Reports Developer and Graphics | |
| |
| |
| Creating a Master-Detail Report Using Report Builder | |
| |
| |
| Using Query Builder to Create Database Queries | |
| |
| |
| Using the Re-entrant Layout Wizard | |
| |
| |
| Using the Report Editor | |
| |
| |
| Using the Object Navigator | |
| |
| |
| Integrating Graphics into Reports | |
| |
| |
| Summary | |
| |
| |
| |
| Query Builder and Schema Builder | |
| |
| |
| More About the Query Builder | |
| |
| |
| Running Query Builder | |
| |
| |
| Creating Lookup Queries | |
| |
| |
| Creating Table Relationships | |
| |
| |
| Saving the Query | |
| |
| |
| The Query Window Toolbar | |
| |
| |
| More Examples | |
| |
| |
| The Results Window Toolbar | |
| |
| |
| Query Builder Conclusion | |
| |
| |
| The Schema Builder | |
| |
| |
| Creating a Table | |
| |
| |
| Creating Relationships | |
| |
| |
| Creating Indexes | |
| |
| |
| Schema Builder Toolbar | |
| |
| |
| Creating Integrity Constraints | |
| |
| |
| Creating Views | |
| |
| |
| Summary | |
| |
| |
| |
| Writing Source Code with Developer | |
| |
| |
| |
| Procedure Builder and PL/SQL | |
| |
| |
| Role of PL/SQL in Developer | |
| |
| |
| Procedure Builder | |
| |
| |
| The Program Unit Editor | |
| |
| |
| The PL/SQL Interpreter | |
| |
| |
| The Object Navigator | |
| |
| |
| The Syntax Palette | |
| |
| |
| The PL/SQL Language | |
| |
| |
| Declaring and Using Variables | |
| |
| |
| Integrating with SQL | |
| |
| |
| Common Language Constructs | |
| |
| |
| Functions | |
| |
| |
| Packages | |
| |
| |
| Database Triggers | |
| |
| |
| Handling Exceptions | |
| |
| |
| PL/SQL in Developer | |
| |
| |
| Summary | |
| |
| |
| |
| Using Java with Oracle Developer and the Oracle Database | |
| |
| |
| Mixing Java and Oracle | |
| |
| |
| Creating Stored Procedures with Java | |
| |
| |
| A Simple Stored Procedure | |
| |
| |
| Using SQL with Java Stored Procedures | |
| |
| |
| Dropping a Stored Procedure Written in Java | |
| |
| |
| Using Java with Oracle Developer | |
| |
| |
| Summary | |
| |
| |
| |
| Application Development with the Developer Tools | |
| |
| |
| |
| Using Graphical Elements in Forms | |
| |
| |
| The Forms Runtime Environment | |
| |
| |
| The Visual Runtime Environment | |
| |
| |
| Hidden Features of the Runtime Environment | |
| |
| |
| A Final Word About the Runtime Environment | |
| |
| |
| Creating a Form Manually | |
| |
| |
| Calculation Fields | |
| |
| |
| Wizards Make Life Easier | |
| |
| |
| Various Visual Elements | |
| |
| |
| Static Images | |
| |
| |
| Push Buttons | |
| |
| |
| List Items | |
| |
| |
| Check Boxes | |
| |
| |
| Radio Buttons and Groups | |
| |
| |
| Chart Wizard | |
| |
| |
| Running the Form in the Debugger | |
| |
| |
| Canvases | |
| |
| |
| List of Values | |
| |
| |
| Dialog Boxes | |
| |
| |
| Summary | |
| |
| |
| |
| More About Reports | |
| |
| |
| Report Examples | |
| |
| |
| Tabular Reports | |
| |
| |
| Form-Like Reports | |
| |
| |
| Mailing Label Reports | |
| |
| |
| Form Letter Reports | |
| |
| |
| Group Left Reports | |
| |
| |
| Group Above Reports | |
| |
| |
| Matrix Reports | |
| |
| |
| Matrix with Group Reports | |
| |
| |
| Report Views | |
| |
| |
| Live Previewer | |
| |
| |
| Data Model | |
| |
| |
| Layout Model | |
| |
| |
| Creating and Modifying Report Templates | |
| |
| |
| Modify an Existing Template | |
| |
| |
| Creating a New Template | |
| |
| |
| Template Summary | |
| |
| |
| Parameter Forms | |
| |
| |
| Summary | |
| |
| |
| |
| Oracle Graphics Builder Development | |
| |
| |
| Chart Types | |
| |
| |
| Bar Charts (Both Horizontal and Vertical) | |
| |
| |
| Line Charts | |
| |
| |
| Pie Charts | |
| |
| |
| Table Charts | |
| |
| |
| Mixed Bar and Line Charts | |
| |
| |
| Double-Y Charts | |
| |
| |
| Scatter Charts | |
| |
| |
| High-Low Charts | |
| |
| |
| Gantt Charts | |
| |
| |
| Chart Type Summary | |
| |
| |
| Drill-Down Charts | |
| |
| |
| Summary | |
| |
| |
| |
| Developer Application Design | |
| |
| |
| Application Background and Requirements | |
| |
| |
| Application Interface | |
| |
| |
| Forms | |
| |
| |
| Reports | |
| |
| |
| Graphics | |
| |
| |
| Review by Big Jim | |
| |
| |
| Database Objects to Create | |
| |
| |
| Tables and Sequences | |
| |
| |
| Indexes | |
| |
| |
| Creating the Database Schema | |
| |
| |
| Summary | |
| |
| |
| |
| Making the Design a Reality | |
| |
| |
| Forms Creation | |
| |
| |
| Three Maintenance Forms | |
| |
| |
| The Events Form | |
| |
| |
| The Signup Form | |
| |
| |
| The Results Entry Form | |
| |
| |
| Reports Creation | |
| |
| |
| The Confirmation Letter | |
| |
| |
| The Results Report | |
| |
| |
| Graphics Creation | |
| |
| |
| Creating a Menu | |
| |
| |
| Possible Enhancements | |
| |
| |
| Summary | |
| |
| |
| |
| Deployment and Optimization of Developer Applications | |
| |
| |
| |
| Deploying Developer Applications to the Web | |
| |
| |
| Understanding Web Deployment of Developer Applications | |
| |
| |
| Forms Server Architecture | |
| |
| |
| Reports Server Architecture | |
| |
| |
| Deploying Forms on the Web | |
| |
| |
| Deploying Reports and Graphics on the Web | |
| |
| |
| Using Java with Your Developer Application | |
| |
| |
| Using Java Stored Procedures and Functions | |
| |
| |
| Java Beans in Forms | |
| |
| |
| Summary | |
| |
| |
| |
| Project Management and Source Code Control | |
| |
| |
| Project Builder | |
| |
| |
| Creating and Adding Files to Project Builder | |
| |
| |
| Building Files with Project Builder | |
| |
| |
| Using the Delivery Wizard | |
| |
| |
| Customizing Project Builder with the Module Type Wizard | |
| |
| |
| Source Code Control | |
| |
| |
| Sample Source Code Control Systems | |
| |
| |
| Source Code Control Using Project Builder | |
| |
| |
| Summary | |
| |
| |
| |
| Guidelines for Building Great Developer Applications | |
| |
| |
| Tuning the Look and Feel | |
| |
| |
| Visual Aspects | |
| |
| |
| Usability | |
| |
| |
| Performance Tuning | |
| |
| |
| All Applications | |
| |
| |
| Forms | |
| |
| |
| Reports | |
| |
| |
| Graphics | |
| |
| |
| Web Deployment | |
| |
| |
| A Final Note on Performance | |
| |
| |
| Developing Multilingual Applications | |
| |
| |
| Considerations | |
| |
| |
| Multilingual Application Caution | |
| |
| |
| Writing Portable Applications | |
| |
| |
| Colors | |
| |
| |
| Fonts | |
| |
| |
| Key-Specific Messages | |
| |
| |
| Summary | |
| |
| |
| Index | |