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.
作者簡(jiǎn)介
暫缺《OCP Building Internet Applications I & II考試指南?》作者簡(jiǎn)介
圖書(shū)目錄
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