Oracle Forms demonstration

1
Oracle Forms demonstration

• delivered by John Stockwell

2
Objectives

• At the end of this lecture you should be able to
• Construct a form containing data blocks
• Use the form to enter records
• Use queries to select required records
• Create master-detail data blocks
• Use features to make the form more user friendly
• List of values
• Format masks
• Triggers
• Radio buttons
• Customised menus
• Procedures and functions
• Alert boxes

3
Order of user interface development

• Create database
• Create data blocks using data block wizard
• Use layout wizard
• Create master-detail data blocks
• Add additional features
• Populate tables

4
Create database

• From design create tables
• Put in primary keys, foreign keys and NOT NULL
  statements as necessary
• See demo on creation of Order database

5
Create data blocks using data block wizard

• Steps
• Create data blocks
• When creating a detail data block
• Use create relationship
• put it on same canvas and tab as master data
  block and choose tabular layout
• See demo on creation of data blocks

6
Add additional features for good screen design

• List of values
• Format masks
• Triggers
• Radio buttons
• Customised menus
• Procedures and functions
• Alert boxes
• See demonstration on features above