Oracle Developer 2000 Handbook

Part I: Building Applications.Introducing Developer/2000.An Overview of Building Applications.Form Applications.Report Applications.Graphics Applications.Applications and Development.What Is Different About Database Applications? Recovery.Concurrency.Data Independence.Referential Integrity.Security.SQL.Data Models.Performance.Database Manager Interfaces.Clients and Servers.Fitting the Pieces Together.A Road Map to Applications Development.Forms.The Form Module.The Menu Module.The Library Module, Built-In Packages, and Database Objects.Reports.Graphics.The Nuts and Bolts.The Development Process.Life Cycles.Defining the Processes.Clarifying Users' Requirements.Design and Prototyping.Coding.Integration and Testing.Deployment.Maintenance.Three Types of Life Cycles.The Waterfall Life Cycle.Prototyping and the Spiral Life Cycle.Rapid Application Development Life Cycles.Part II.Prototyping and Designing.What You See Is What You Get.What To Do First.The Requirements Jungle.Exploring Requirements.The Explorer's Equipage.From the Jungle to the Farm.A Proposed Life Cycle for Talbot's Systems.Talbot's Requirements.A Little Database.Project Management.Developing Forms.Developing Reports.Some Rules for Setting Up Forms and Reports.Communication.Flexibility.Simplicity.Performance.Assistance.Prototyping.Developing Form Prototypes.Launching.Creating the Form.Saving Your Prototype.Developing a Simple Summary Report.Prototyping a Report With the Report Wizard.Prototyping a Report Without the Report Wizard.Adding Graphics to Your Forms and Reports.Prototyping Graphics Using Integrated Wizards.Prototyping Graphics from Scratch.Usability Testing and Feedback.User Satisfaction Surveys.Taking It to the Next Level.Developer/2000 Processes and Triggers: How It All Works.Forms Processes and Triggers.Reports Process and Triggers.Graphics Process and Triggers.Cross-Platform Redesign.Control and Menus Standards.Colors and Patterns.Fonts.Platform-Specific Functionality.Standards and Planning.Doing Windows.Windows.Painting Canvases.Viewing Through Windows.Blocks.Lists.Radio Buttons.Calculated Items.Date and Time Items and Format Masks.Menus.Using the Default Menu.Creating Custom Menus.Reporting Back.Modeling Report Data.Groups.Formula Columns.Summary Columns.Multiple Queries and Data Links.Formatting Reports.The Live Previewer.The Layout Editor.Elasticity and Sizing.Formatting Tools.Buttons and Interactive Reports.A Report Bestiary.Tabular and Group Reports.Form Reports.Mailing-Label Reports.Matrix Reports.Data File Export Reports.Graphic Descriptions.Effectively Using Graphics.Building Charts.Getting Data for Your Charts.Building Line Charts.Modifying Charts.Building Bar Charts.Building Pie Charts.Building Drill-Down Charts.Laying Out Displays.Drawing Shapes, Images, and Sounds.Adding Triggers for Setup and Formatting.No Entry.Why Be Secure? Discretionary Access Control.SQL Access Control.ORACLE7 Access Control.Client Security.Auditing.Auditing in ORACLE7.Client Audit Trails.Mandatory Access Control.Trusted ORACLE7.Keeping Talbot's Safe.Talbot's Security Risks.Talbot's ORACLE7 Security Architecture.Talbot's Application Security.Advanced Design for Reuse.Recycling: Everyone Should Do It.Modules.Templates and Components.External Queries and the Query Builder.Named Visual Attributes.Property Classes.Subclassing, Copying, and Referring to Objects.When to Do What.Getting Into Arguments.Forms Parameters.Report Parameters.In Triplicate? Opening Forms.Multi-Form Transactions.Closing Forms.Why Do It Six Times When You Can Do It Once? Part III: Implementing, Testing, and Debugging.Real Programmers.A Brief Introduction to Data.Data Types.Declaring Variables and Constants.Using Type Attributes.An Even Briefer Introduction to Control.Conditional Control.Iteration Control.Using SQL in PL/SQL.Simple SQL.Using Explicit Cursors.Using Cursor Variables.Data Definition SQL.Super Programmers.Making Exceptions.PL/SQL Built-In Exceptions.User-Defined Exceptions.Using Blocks to Control Exception Handling.Error-Handling Functions.Making Blocks Less Anonymous.Subprograms.Nesting Blocks.Positioning Blocks in the Navigator.Creative Packaging.Using a Package.Built-In Packages.Checking Out the Library.Creating a Library.Attaching and Using a Library.Pest Control.The Best Offense.Inside-Outside Quality.Testing Objects.Object Test Models, Cases, and Scripts.Domain Partitioning.Testing SQL.Testing Systems.Validation.Capability Testing.Automated Testing.Debugging.The Art of Debugging.Locating Faults by Introduction.Locating Faults by Deduction.Locating Faults by Tracing.Fault Location Techniques.Fixing Faults.Debugging Developer/2000 Objects.The Debugger.Tracing Forms.Tracing Reports.Tracing SQL and Client/Server Events.Part IV: Deploying Forms with Other Tools.Getting It Out There and Keeping It Out There.Deploying Your Application.Things to Worry About.Installation.Deployment.Maintaining Your Application.Failure and Fault Tracking.Configuration Management.The Maintenance Release Life Cycle.Product Euthanasia.You're Not Alone.Integrating Oracle Products.Forms Integration Tools.Graphics Displays in Reports.Designer/2000.Using Other Database Managers with ODBC.ORACLE Terminal for Key Assignments in Forms 670.Part V: Appendices: A: The Database.Dropping the Tables.Creating the Physical and Logical Schemas.Creating the Data.The Lodging Table.The Skill Table.The Person Table.The WorkerHasSkill Table.The Ledger Table.B: Translation Tools.National Language Support in ORACLE7.Layout Design.String Translation.Boilerplate Text.The Translation Builder.PL/SQL Strings.