Basic Developer/2000 Concepts
- Architecture and components of tool set
- The client/server implementation
Building Forms
Creating a Form
- Using the Object Navigator
- Defining base table blocks
Using the Layout Editor
- Working with interface items
- Manipulating, arranging and formatting interface items as objects
- How to define a consistent interface
- Providing relevant user feedback objects
- Selecting names, color and layout
Providing user feedback
- Developing usefulnavigation aids
- Creating alert boxes
PL/SQL programming
- Developing well-structuredcode
- Using local, global andsystem variables
Procedures and functions
- When to useOracle-supplied routines
- Creating user-namedroutines
- Using the Forms library tostore reusable code
Debugging Forms
- Tracing triggers
- Using the debugger facility
- Break points and stackvariables
Defining blocks and block relations
- Block navigation
- WHERE and ORDER BYclauses
- Exploiting master-detailrelationships
Creating list of values and record groups
- Creating record groups
- Designing queries todisplay a list of values (LOV)
Designing windows and canvasviews
- Content views
- Stacked views
|
Building well-designed menus
- Using the Menu Editor
- Creating magic menu items
Building Reports
The basic techniques
- Using default options
- Using the Data Model Editor
- Applying queries, groups and summaries
Designing report layouts
- Specifying and developing layout components
- Editing and manipulating layout objects
- Creating master-detail and tabular layout formats
Applying advanced techniques
- Building matrix reports
- Using triggers for validating & formatting
Parameters and summarization
- Utilizing user, system & lexical parameters
- Defining and building parameter screens
- Implementing group- and report-level data summaries
Building Graphs
Examining Graphics components
- Chart items and their properties
- Data queries
- Categories
- Category values
Building graphical displays
- Editing the layout
- Defining chart items and specifying queries used for populating the chart
- Testing and executing graphical displays
Creating drill-down charts
- Passing parameters between master and detail charts
- Using layers to navigate between drill-down levels
Integrating Developer/2000 components
- Creating integrated applications using menus, forms, reports and graphs
- Passing parameters between forms
Communicating between modules
Case Study |