Oracle Forms Training

Oracle Forms Training course is designed for those who wish to learn advanced database programming concepts using Oracle. It will enable participants to develop, implement and deploy reports using oracle’s forms and reports applications. Participants can learn how to create forms for internet applications with user input items.

Duration : 30 Hrs
Prerequisites: Oracle Database: Oracle Database: SQL & PL/SQL

Oracle Forms Training course content

Introduction to Oracle Forms Developer and Oracle Forms Services
- Describe the components of Oracle Developer Suite and the Oracle Application Server
- Describe the features and benefits of Oracle Forms Services and Oracle Forms Developer
- Describe the architecture of Oracle Forms Services
- Describe Forms Builder components
- Navigate the Forms Builder interface
- Customize the Forms Builder session
- Use the online help facilities
Running a Forms Developer Application
- Describe the run-time environment
- Explain the role of each
- Modify Forms environment variables
- Describe the appearance of a form at run time
- Navigate a Forms application
- Retrieve both restricted and unrestricted data
- Describe the two modes of operation
- Insert, update, and delete records
- Display database errors
Working in the Forms Developer Environment
- Describe the main Forms Developer executable
- Describe the main Forms Developer module types
- Describe the main objects in a form module
- Run a form from within Forms Builder
- Start and stop an OC4J instance
- Set Forms Builder preferences to use OC4J
Creating a Basic Form Module
- Create a form module
- Create data blocks, create data blocks with relationships and create control blocks
- Use wizards in re-entrant mode to make changes to the data block and layout
- Save and compile a form module
- Describe Forms file formats and their characteristics
- Explain how to deploy a form module
- Produce text files and documentation
- Run a master-detail form module
Creating Master Details Forms.
- Create data blocks with relationships
- Modify a data block
- Modify the layout of a data block
- Run a master-detail form
Working with Data Blocks and Frames
- Describe the methods to modify object properties
- Describe the features of the Property Palette
- Manipulate properties through the Property Palette
- Display the Property Palette
- Describe the property controls for different types of properties
- Display multiple Property Palettes
- Set properties on multiple objects
- Copy properties
- Control the behavior and appearance of data blocks
- Use visual attributes
- Use font, pattern, and color pickers
- Set navigation properties
- Set records properties
- Set database properties
- Set scrollbar properties
- Control frame properties
- Delete data blocks and their components
Working with Text Items
- Describe text items
- Create a text item
- manage and modify text items using the property palette
- Display helpful messages
Creating LOVs and Editors
- Describe LOVs and editors
- Design, create, and associate LOVs with text items in a form module
- Describe the relationship between LOVs and record groups
- Explain the steps to create an LOV manually
- Use the LOV Wizard to create an LOV
- Set LOV properties
- Create editors and associate them with text items in a form module
Creating Additional Input Items
- Describe the item types that allow input
- Create a check box
- Create a list item
- Create a radio group
Creating No input Items
- Describe item types that do not allow input
- Create a display item
- Create an image item
- Create a button
- Create a calculated item
- Create a hierarchical tree item
- Create a bean area item
Creating Windows and Content Canvases
- Define windows, content canvases, and viewports
- Describe the relationship between windows and content canvases
- Create windows and content canvases
- Display a form module in multiple windows and on multiple layouts
Working with Other Canvas Types
- Describe the different types of canvases and their relationships to each other
- Identify the appropriate canvas type for different scenarios
- Create an overlay effect by using stacked canvases
- Create a toolbar
- Create a tabbed interface
Introduction to Triggers
- Define triggers
- Describe the different trigger categories
- Describe the components of a trigger
- Describe the types of statements used in trigger code
- Describe the properties that affect the behavior of a trigger
Producing Triggers
- Write trigger code
- Create a trigger of appropriate type and scope
- Describe the features of the PL/SQL Editor
- Describe the features of the Database Trigger Editor
- Explain the structure of trigger code
- Use variables in triggers
- Explain the use of built-in subprograms in Forms applications
- Describe the When-Button-Pressed trigger
- Describe the When-Window-Closed trigger
Debugging Triggers
- Describe the methods to debug triggers in Forms Builder
- Describe the components of the Debug Console
- Run a form module in debug mode by using the Run Form Debug button
- Debug PL/SQL code
- Set breakpoints in code
- Step through code
- View variable values while form is running
Adding Functionality to Items
- Describe item interaction triggers
- Supplement the functionality of input items by using triggers and built-ins
- Code interactions with radio groups
- Code interactions with check boxes
- Change list items at run time
- Display an LOV from a button
- Supplement the functionality of noninput items by using triggers and built-ins
- Populate image items
- Populate hierarchical trees
- Code interactions with JavaBeans in the bean area item
Run Time Messages and Alerts
- Describe the default messaging behavior of a form
- Handle run time failure of built-in subprograms
- Describe the different types of Forms Builder messages
- Cause a trigger to fail in a controlled manner
- Control system messages
- Create and control alerts
- Handle database server errors
Query Triggers
- Explain the processes involved in querying a data block
- Describe query triggers and their scope
- Control query array processing
- Write triggers to modify query behavior
- Control trigger action based on the form’s query status
- Obtain query information at run time
Validation
- Describe the validation process
- Control validation:
- Using object properties
- Explain the effects of the validation unit upon a form
- Use an LOV for validation
- Using triggers
- Using Pluggable Java Components
- Describe how Forms tracks validation status
- Control when validation occurs
Navigation
- Describe how navigation affects the navigation unit and the cursor
- Distinguish between internal and external navigation
- Control navigation with properties
- Describe and use navigation triggers to control navigation
- Explain how the cursor can become stuck between two items, resulting in a navigation trap
- Use navigation built-ins in triggers
Transaction Processing
- Explain the process used by Forms to apply changes to the database
- Describe the commit sequence of events
- Describe the characteristics and uses of commit triggers
- Supplement transaction processing
- Perform delete validation
- Allocate sequence numbers to records as they are applied to tables
- Keep an audit trail
- Test the results of trigger DML
- Override default transaction processing
- Describe how to run against a non-Oracle data source
- Get and set the commit status
- Implement array DML
Writing Flexible Code
- Describe flexible code
- Use system variables to determine:
- Cursor focus
- Trigger focus
- Commit status
- Describe built-in subprograms that assist flexible coding
- Write code to reference objects:
- By internal ID
- Indirectly
Sharing Objects and Code
- Describe benefits of reusing objects and code
- Create and use property classes
- Describe property classes
- Create property classes
- Add properties to property classes
- Inherit properties from property classes
- Explain the inheritance symbols in the Property Palette
- Group related objects for reuse
- Copy and subclass objects
- Reuse objects from an object library
- Describe object libraries
- Describe the benefits of using object libraries
- Create object libraries
- Populate object libraries
- Modify objects in an object library
- Create and use SmartClasses
- Reuse PL/SQL code
Using WebUtil to Interact with the Client
- Describe the benefits of the WebUtil utility
- Integrate WebUtil into a form
- Use WebUtil to interact with a client machine
Introducing Multiple Form Applications
- Describe the characteristics of multiple form applications
- Describe the benefits of multiple form applications
- Call one form from another form module
- Define multiple form functionality
- Share data among open forms
- Control opening and closing of multiple forms
- Synchronize data among multiple form
Creating a Menu Module
- Describe the different components of a menu module
- Create, save and attach menu modules
- Set menu properties using the Property Palette
- Create menu toolbars
- Create pop-up menus
Managing Menu Modules
- Control menus programmatically
- Manage the interaction between the menu and form documents
- Implement application security through the menu
Building Multiple Form Applications
- Describe the various ways of invoking additional forms modules
- Open and close form modules
- Navigate between form modules
- Control open form modules
- Choose the most appropriate method for invoking forms