The first two exams are the basis of numerous Oracle certifications, and they can be prepared for using a variety of SQL and PL/SQL books. (In fact, you can prepare for the first exam using the Oracle Press book PL/SQL 101, which I wrote. 1 don t mean to be self-serving in mentioning it-I really believe its the best preparation available for the first exam.
　　This book covers the last two exams, and it contains two units-one for each exam. Within each unit, you will find a number of chapters that teach the information you need to know to achieve a successful score on the related exam.

About the Author
　　 Christopher Allen has been a database professional for over 20 years and has provided computer consulting services for clients such as IBM, Dell, Microsoft, Universal Studios, the California Institute of Technology, and the Department of Justice. He has programmed hundreds of customer applications and has taught more than a thousand computer classes for professionals.
　　 Allen is an Oracle Certified Professional DBA and OCP Internet Developer. He is the author of PL/5QL 101, co-author of the OCP Financial Applications Consultant Exam Guide, and co-author of the OCP Application Developer Exam Guide.

The Oracle Internet Application Developer certification track consists of four exams:
　　Introduction to Oracle: SQL and PL/SQL
　　Develop PL/SQL Program Units
　　Build Internet Applications 1
　　Build Internet Applications 11
　　The first two exams are the basis of numerous Oracle certifications, and they can be prepared for using a variety of SQL and PL/SQL books. (In fact, you can prepare for the first exam using the Oracle Press book PL/SQL 101, which I wrote. 1 don t mean to be self-serving in mentioning it-I really believe its the best preparation available for the first exam.)
　　This book covers the last two exams, and it contains two units-one for each exam. Within each unit, you will find a number of chapters that teach the information you need to know to achieve a successful score on the related exam.
　　How Chapters Are Organized
　　The chapters in this book observe the following format:
　　Discussion Sections
　　Each subject covered in an exam will be addressed with a discussion section in this book. Each discussion section will be immediately followed by a brief set of questions that review the material just presented. The answers to these questions are not printed elsewhere in the book; the idea is that if you read the questions and don t know the answers, you have not absorbed the information just presented, and you should go back and reread it before you continue forward.
　　Chapter Summaries
　　Each chapter closes with a summary of the chapters main points. In addition to helping drive home the important points after you have read the discussion sections,this compressed review is a powerful, efficient review tool to use before you take the exam. After you have gone through a unit in the book and have scheduled to take the related exam, I recommend that you reread the relevant summaries once a day for several days preceding the exam. This will keep the material fresh in your mind with very little time investment.
　　Two-Minute Drills
　　Following the chapter summary, the same information is presented in an even briefer format: as a series of bullet points called Two-Minute Drills. These are great to read over just before you go in to take your exam.
　　Chapter Questions and Answers
　　The final part of each chapter is a series of multiple-choice questions that emulate the questions you will encounter in the actual exam. After the questions, you will find the answers, along with an explanation of why the correct answer is correct and why the others choices are not. Answer these questions after reading the chapter. If you get 85 percent or more correct, proceed to the next chapter. If.you don t, go back and read the chapter sections related to the questions you missed, and then wait a couple of days and answer the sample questions again.
　　Conventions Used in This Book
　　Bold text indicates text that you will type as shown. Italics are used to identify new terms the first time they are presented, as well as to emphasize key facts. Items that deserve special notice are set apart as Notes or Tips. They look like this:
　　NOTE
　　Remember of do all the right things and to not do the things that aren't.
　　TIP
　　Never tie your shoelaces together before a hike.
　　How to Get the Most Out of This Book You must do three things to get the most out of this book:
　　1. Do.
　　2. The.
　　3. Exercises.
　　The exercises take the "book learning," which is quickly forgotten, and put it into your hands, where it can be retained for a long, long time. Through the course of this book, you will go through the steps to create a variety of new forms for working with data. If you want to really maximize your learning and retention, do the exercises, and then do them again with an application of your own. Your application can be real or fancifui-it doesnt matter. The magical retention phenomenon called "transferring the knowledge" will happen either way.
　　The only exception to doing the exercises is if you are a seasoned Oracle Forms professional who has created numerous forms already. If this is the case, you can test out of a chapter by going directly to the questions at the end of the chapter,answering them, and checking your score. if you get 85 percent or more of the answers right, and you are pressed for time, its worthwhile to consider skipping that chapter and proceeding to the next one, which you might test out of as well.
　　

（美）Christopher Allen：暂无简介

PREFACE
ACKNOWLEDCMENTS
INTRODUCTION
PART
Preparing for OCP Exam 3: Build Internet Applieations I
I 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
S 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
e 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
II 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