PREFACE
ACKNOWLEDCMENTS
INTRODUCTION
PART I
Preparing for OCP Exam 3: Build Internet Applieations I
1 Introduction to Oracle Forms
Overview of the Oracle Forms 6i Package
Features and Benefits of Using Oracle Forms 6i
Component Groups in Oracie Forms 6i
Introduction to Oracle Forms 6i Builder Tools
Builder Tools for Project Management
Builder Tools for Front-End Development
Builder Tools for Back-End Development
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
2 Form Builder
Working in the Form Builder Environment
Identifying the Main Form Builder Executables
Identifying the Main Components of Form Builder
Identifying the Main Objects in a Form Module
Creating Basic Form Modules
Creating a Form Module
Using the Data Block Wizard to Create and Modify Data Blocks
Creating and Modifying Layouts Using the Layout Wizard
Saving, Compiling, and Running a Form Module
Form Builder File Formats and Their Characteristics
Creating Data Blocks with Relationships
Running a Master/Detail Form Module
Running a Form Builder Application
Understanding the Runtime Environment
Navigating a Form Builder Application
Understanding the Two Modes of Forms Runtime Operation
Retrieving Data into a Form Builder Application
Inserting, Updating, and Deleting Records
Displaying Database Errors Using the Help Facility
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
3 Forms Design l
Working with Data Blocks and Frames
Property Palette Components
Manipulating Properties
Controlling the Behavior of Data Blocks
Controlling Frame Properties
Creating Blocks That Do Not Correspond to a Database Object
Deleting Data Blocks and Their Components
Working with Text Items
Introduction to Text Items
Modifying a Text Item s Appearance
Controlling the Data in a Text Item
Modifying the Navigational Behavior of a Text Item
Enhancing the Relationship Between the Text Item and a Database
Modifying the Functionality of a Text Item
Including Help Messages in Your Applications
Creating LOVs and Editors
Introduction to LOVs and Editors
Creating LOVs
Creating Editors
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
4 Forms Design II
Creating Additional Input Items
Introduction to Item Types that Allow Input
Creating a Check Box
Creating a List Item
Creating a Radio Group
Creating Noninput Items
Introduction to Item Types that Do Not Allow Input
Creating a Display Item
Creating an Image Item
Creating a Sound Item
Creating a Button
Creating a Calculated Field
Creating Windows and Content Canvases
introduction to Windows and Content Canvases
Window and Content Canvases Properties
Displaying a Form Module in Multiple Windows
Working with Other Canvases
Introduction to Canvas Types
Creating an Overlay Effect Using Stacked Canvases
Creating a Toolbar
Creating a Tabbed Interface
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
5 Working with Triggers
Introduction to Form Triggers
Definition of a Trigger
Form Trigger Categories
Form Trigger Types and Scope
Form Trigger Properties
How to Produce Triggers
Writing Trigger Code
Understanding the Use of Built-In Subprograms
Introduction to the When-Window-Closed Trigger
Adding Functionality to Form Items
Supplementing the Functionality of Input Items
Supplementing the Functionality of Noninput Items
Using Query Triggers
Data Block Query Process and Triggers
Writing Triggers That Screen Query Conditions
Writing Triggers to Supplement Query Results
Debugging Triggers
Running a Form Module in Debug Mode
Understanding the Components of the Debugger
Debugging PL/SQL Code
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
6 Forms Processing
Forms Runtime Messages and Alerts
Introduction to the Default Messaging
Handling Errors Using Built-In Subprograms
Controlling System Messages
Creating and Controlling Alerts
Data Validation
Effects of the Validation Unit on a Form
Introduction to Form Builder Validation Properties
Controlling Validation Using Triggers
Navigation
Internal versus External Navigation
Using Navigation Triggers
Introduction to Built-Ins That Cause Navigation
Transaction Processing
Commit Processing, Transaction Processing, and Triggers
Allocating Automatic Sequence Numbers to Records
Implementing Array DML
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
7 Forms Programming
Writing Flexible Code
Flexible Code and System Variables
Built-In Subprograms that Assist Flexible Coding
Writing Code to Reference Objects by Internal ID
Writing Code to Reference Objects Indirectly
Sharing Objects and Code
Inheriting Properties from Property Classes
Grouping Related Objects for Reuse
Reusing Objects from an Object Library
Reusing PL/SQL code
Managing Multiple-Form Applications
Defining Multiple-Form Functionality
Calling One Form from Another
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
PART II
Preparing for OCP Exam 4: Build Internet Applications II
8 Working with Nenu Modules
Creating Menu Modules
Menu Components
Creating, Saving, and Attaching Menu Modules
Setting Menu Properties Using the Property Palette
Creating Menu Toolbars
Creating Pop-up Menus
Managing Menu Modules
Controlling the Menu Programmatically
Customizing Menu Modules with Substitution Parameters
Implementing Menu Security
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
9 Advanced Forms Programming I
Programming Function Keys
Redefining Function Keys
Determining When Key Triggers Should Be Used
Responding to Mouse Events
Introduction to Mouse Events
Causing a Form Module to Respond to Mouse Movement
Causing a Form Module to Respond to Mouse Button Actions
Controlling Windows and Canvases Programmatically
Creating Trigger Code to Interact with Windows
Controlling Windows Programmatically
Controlling Canvases
Controlling Data Block Relationships
Definition of Block Coordination
Ereating and Modifying Relations
Characteristics of Relation-Handling Code
Implementing a Coordination-Type Toggle
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
10 Advanced Forms Programming
Building Multiple-Form Applications
Different Ways to Invoke Forms
Building Robust Multiple-Form Transactions
Passing Data Between Forms Using Parameter Lists
Defining Data Sources
Introduction to Diverse Data Source Types
Selecting Appropriate Data Sources for Data Blocks
Working with Record Groups
Creating Record Groups at Design Time
Creating and Modifying Record Groups Programmatically
Building Dynamic List Items by Using Record Groups
Using a Global Record Group to Communicate Between Forms
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
11 Advanced Forms Programming III
Including Charts in Forms
Using the Chart Wizard to Embed Charts in a Form
Applying Timers to Form Objects
Creating a Timer
Deleting a Timer
Modifying a Timer
Utilizing Reusable Components
Introduction to the Reusable Components
Using the Calendar Class in an Application
Using Server Features in Form Builder
Introduction to Oracle Server Features in Form Builder
Partitioning PL/SQL Program Units
Recognizing the PL/SQL8 Features Supported in Forms 6i
Handling Errors Raised by the Oracle Server
Performing DDL Commands
Chapter Summary
Two-Minute Drill
Chapter Questions
Answers to Chapter Questions
Index
鄂公网安备 42010302001612号 