Course Content
INTRODUCTION AND OVERVIEW
- Database, Forms and Reports
- Introduction to Oracle Database
- Physical Database Design
- Database Management
- Tables, Views, Indexes, Synonyms, Grants, Roles
- Installing Oracle Forms and Reports
- Architecture and toolset
- Testing forms and reports
DESIGN PRINCIPLES
- Using Form Builder Client/Server
- Defining a consistent interface
- Implementing user interface items
- Selecting names, colour and layout
- Building well-designed menus
- Using the Menu Editor
- Creating magic menu items and Alerts
- Multi form applications
- Screen Formation
- Object Navigator, Blocks, Canvas, Windows
FORM BUILDER
- Creating a Oracle Form
- Oracle Form Designer
- Elements of Form Designers, Menus and Libraries
- Building single and master / Detail Forms
- Using the Object Navigator
- Defining data blocks using the Data Block Wizard
- Using the Layout Editor
- Working with interface items
- Manipulating, arranging and formatting interface items
SQL STATEMENTS AND QUERIES
- Data Types
- Table Structure
- Create Table
- Insert Table
- Select Table, where, like etc
- Alter Tables, Columns
- Update Table
- Elements of Form Designers, Menus and Libraries
FORM BUILDER OPERATIONS WITH PL/SQL
- PL/SQL programming
- Developing well-structured code
- Using local, global and system variables
- PL/SQL Character set
- Variables
- IF clause, LOOPS, Null Clause, Exception handlers
- Error handling, cursor
- PL/SQL tables
- Procedures, Functions and Triggers
- Using Oracle-supplied routines
- Creating user-named routines
- Using a library to store reusable code
- Stored Procedures
- Creating Triggers
- Coding and Compilation
- Debugging techniques in Form Builder
- Tracing Trigger Operation
- Using the debugger facility
- Break points and stack variables
- Defining block and relation properties
- Block navigation
- WHERE and ORDER BY clauses
- Implementing master-detail relationships
- Creating a list of values and record group objects
- setting record group properties
- Designing queries to populate a list of values (LOV)
- Designing windows and canvases
- setting properties of content, stacked, toolbar and tab canvases
- using the Layout Wizard
DESIGNING AND BUILDING REPORTS
- The basic techniques
- Setting default options
- Using the Report Wizard
- Creating the report data model
- Designing report layouts
- Specifying and developing layout objects
- Editing and manipulating layout objects
- Creating master-detail and tabular reports
- Applying advanced techniques
- Using triggers for validating parameters
- Manipulating report format dynamically using triggers
CHARTS AND DISPLAYS WITH GRAPHICS BUILDER
- Examining Graphics Builder components
- Chart items and their properties
- Data queries
- Categories and values
- Building graphical displays
- Editing the layout
- Defining chart items and specifying queries used for populating the chart
- Testing and executing displays
- Creating drill-down charts
- Passing parameters between master and detail charts
- Using layers to navigate between drill-down chart levels
BUILDING APPLICATIONS
- Integrating Forms and Reports modules
- Creating integrated applications
- Passing parameters between Form Builder modules