OCP Building Internet Applications Ⅰ& Ⅱ考试指南 英文版2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载

OCP Building Internet Applications Ⅰ& Ⅱ考试指南 英文版PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Preparing for OCP Exam 3:Build Internet Applications 13

1 Introduction to Oracle Forms 6i3

Overview of the Oracle Forms 6i Package4

Features and Benefits of Using Oracle Forms 6i4

Component Groups in Oracle Forms 6i6

Introduction to Oracle Forms 6i Builder Tools7

Builder Tools for Project Management8

Builder Tools for Front-End Development8

Builder Tools for Back-End Development9

Chaptet Summary13

Two-Minute Drill15

Chapter Questions16

Answers to Chapter Questions21

2 Form Builder25

Working in the Form Builder Environment26

Identifying the Main Form Buildre Executables27

Identifying the Main Components of Form Builder28

Identifying the Main Objects in a Form Module29

Creating Basic Form Modules31

Creating a Form Module32

Using the Data Block Wizard to Create and Modify Data Blocks33

Creating and Modifying Layouts Using the Layout Wizard38

Saving Compiling and Running a Form Module44

Form Builder File Formats and Their Characteristics46

Creating Data Blocks with Relationships48

Running a Master/Detail Form Module51

Running a Form Builder Application51

Understanding the Runtime Environment52

Navigating a Form Builder Application54

Understanding the Two Modes of Forms Runtime Operation57

Retrieving Data into a Form Builder Application58

Inserting Updating and Deleting Records61

Displaying Database Errors Using the Help Facility62

Chaptet Summary64

Two-Minute Drill65

Chapter Questions67

Answers to Chapter Questions72

3 Forms Desing Ⅰ75

Working with Data Blocks and Frames76

Property Palette Components77

Manipulating Properties80

Controlling the Behavior of Data Blocks81

Controlling Frame Properties83

Creating Blocks That Do Not Correspond to a Database Object84

Deleting Data Blocks and Their Components85

Working with Text Items87

Introduction to Text Items88

Modifing a Text ltem s Appearance88

Controlling the Data in a Text ltem89

Modifying the Navigational Behavior of a Text ltem91

Enhancing the Relationship Between the Text ltem and a Database92

Modifying the Functionality of a Text ltem92

Including Help Messages in Your Applications93

Creating LOVs and Editors95

Introduction to LOVs and Editors96

Creating LOVs100

Creating Editors104

Chapter Summary106

Two-Minute Drill109

Chapter Questions112

Answers to Chapter Questions121

4 Forms Design 11127

Creating Additional Input ltems128

Introdction to ltem Types that Allow Input128

Creating a Check Box130

Creating a List Item132

Creating a Radio Group133

Creating Noninput Items137

Introduction to Item Types that Do Not Allow Input138

Creating an Image Item139

Creating a Display Item139

Creating a Sound Item144

Creating a Button147

Creating a Calculated Field149

Creating Windows and Content Canvases150

Introduction to Windows and Content Canvases150

Window and Content Canvases Properties151

Displaying a Form Module in Multiple Windows154

Working with Other Canvases154

Introduction to Canvas Types155

Creating an Overlay Effect Using Stacked Canvases156

Creating a Toolbar158

Creating a Tabbed Interface159

Chapter Summary163

Two-Minute Drill165

Chapter Questions168

Answers to Chapter Questions173

5 Working with Triggers175

Introduction to form Triggers176

Definition of a Trigger176

Form Trigger Categories177

Form Trigger Types and Scope178

Form Trigger Properties178

How to Produce Triggers178

Writing Trigger Code180

Understanding the Use of Built-In Subprograms181

Introduction to the When-Window-Closed Trigger184

Supplementing the Functionality of Input Items186

Addign Functionality to Form Items186

Supplementign the Functionality of Noninput Items187

Using Query Triggers189

Data Block Query Process and Triggers189

Writing Triggers That Screen Query Conditions191

Writing Triggers to Supplement Query Results194

Debugging Triggers195

Running a Form Module in Debug Mode195

Understanding the Components of the Debugger197

Debugging PL/SQL Code199

Chapter Summary201

TWO-Minute Drill203

Chapter Questions206

Answers to Chapter Questions210

6 Forms Processing213

Forms Runtime Messages and Alerts214

Introduction to the Default Messaging215

Handling Errors Using Built-In Subprograms216

Controlling System Messages218

Creating and Controlling Alerts219

Data Validation222

Effects of Validation Unit on a form222

Introduction to Form Builder Validation Properties223

Controlling Validation Using Triggers223

Navigation225

Internal versus External Navigation225

Using Navigation Triggers226

Transaction Processing229

Introdction to Built-Ins That Cause Navigation229

Commit Processing Transaction Processing and Triggers231

Allocating Automatic Sequence Numbers to Records237

Implementing Array DML239

Chapter Summary240

Two-Minute Drill242

Chapter Questions244

Answers to Chapter Questions247

7 Forms Programming249

Writing Flexible Code250

Flesible Code and System Variables250

Built-In Subprograms that Assist Flexible Coding254

Writing Code to Reference Objects by Internal ID257

Writing Code to Reference Objects Indirectly259

Inheriting Properties from Property Classer260

Sharing Objects and Code260

Grouping Related Objects for Reuse263

Reusing Objects from an Object Library264

Reusing PL/SQL code265

Managing Multipe-Form Applications266

Defining Multiple-Form Functionality266

Calling One Form from Another267

Chapter Summary272

Two-Minute Drill274

Chapter Questions276

Answer to Chapter Questions280

Preparing for OCP Exam 4:Build Internet Applications Ⅱ285

8 Working with Menu Modules285

Menu Components286

Creating Menu Modules286

Creating Saving and Attaching Menu Modules288

Setting Menu Properties Using the Property Palette292

Creating Menu Toolbars292

Creating Pop-up Menus295

Managing Menu Modules296

Controlling the Menu Programmatically297

Customizing Menu Modules with Substitution Parameters298

Implementing Menu Security299

Chapter Summary300

Two-Minute Drill303

Chapter Questions305

Answers to Chapter Questions309

9 Advanced Forms Programming 1311

Redefining Function Keys312

Programming Function Keys312

Determining When Key Triggers Should Be Used313

Responding to Mouse Events315

Introduction to Mouse Events315

Causing a Form Module to Respond to Mouse Movement317

Causing a Form Module to Respond to Mouse Button Actions318

Controlling Windows and Canvases Programmatically319

Creating Trigger Code to Interact with Windows319

Controlling Windows Programmatically319

Controlling Canvases321

Controlling Data Block Relationships321

Definition of Block Coordination322

Creating and Block Coordination322

Characteristics of Relation-Handling Code325

Implementing a Coordination-Type Toggle331

Chapter Summary332

Two-Minute Drill334

Chapter Questions337

Answers to Chapter Questions341

10 Advanced Forms Programmign343

Building Multiple-Form Applications344

Different Ways to Invoke Forms344

Building Robust Multiple-Form Transactions346

Passing Data Between Forms Using Parameter Lists348

Defining Data Sources350

Introduction to Diverse Data Source Types351

Selecting Appropriate Data Sources for Data Blocks352

Working with Record Groups355

Creating Record Groups at Design Time356

Creating and Modifying Record Groups Programmatically357

Building Dynamic List ltems by Using Record Groups359

Using a Globab Record Group to Communicate Between Forms360

Chapter Summary362

Two-Minute Drill364

Chapter Questions366

Answers to Chapter Questions370

11 Advanced Forms ProgrammingⅢ373

Including Charts in Forms374

Using the Chart Wizard Embed Charts in a Form374

Applying Timers to Form Objects377

Creating a Timer377

Deleting a Timer380

Modifying a Timer381

Utilizing Reusable Components382

Introduction to the Reusable Components382

Using the Calendar Class in an Application384

Using Server Features in Form Builder384

Introduction to Oracle Server Features in Form Builder385

Partitioning PL/SQL Program Units385

Recognizing the PL/SQL8 Features Supported in Forms 6i386

Handling Errors Raised by the Oracle Server388

Performing DDL Commands389

Chapter Summary390

Two-Minute Drill392

Chapter Questions394

Answers to Chapter Questions399

Indes403