OCP Building Internet Applications I & II Exam Guide

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