Oracle10g ODS Forms I Build Internet Applications

This five day course provides a comprehensive foundation in SQL language and Oracle's SQL*Plus extensions. This course will teach students about creating and maintaining table definitions in the data dictionary, specifying data types, manipulating tables and developing sophisticated queries quickly and accurately.

The objective of this course is provide application software developers with the skills to build enterprise-scale Internet applications using the Oracle10g ODS Forms product. Major subject areas to be explored are:

• Rapidly build form applications using the wizards and other productivity features.
• Building complex form modules using the Forms Builder.
• Building menu bar modules using Forms Builder.
• Customizing the precise appearance of modules using the Layout Editor.
• Linking individual modules within an application.
• Including simple PL/SQL programs to customize module behavior.
• Understanding the Oracle Forms runtime environment

Target audience

The target audience for this course is application developers and designers, as well as their management, who will be developing Internet applications using the Oracle10g ODS Forms product. The following courses are mandatory prerequisites for this course:

• Introduction to Oracle10g: SQL
• Introduction to Oracle10g: PL/ SQL
• Introduction to Oracle10g: Advanced SQL
• Develop Oracle10g PL/SQL Program units

Certification Examination

Tests for the Oracle Certified Professional program are administered by Sylvan Prometric, Inc. This course applies to the certification as an "Oracle PL/SQL & Forms Developer". Specifically, this course considers subjects included within the examination entitled "Oracle Forms Developer: Build Internet Applications". The course “Oracle10g ODS Forms II: Customize Internet Applications” is also required to complete the subject matter for these examinations. Following the training sessions Oracle Corporation recommends six-months production experience with the technology prior to taking the certification examinations. While this is good practice it may not be necessary for all individuals.

Course content

About the wizards An introduction to the wizards • Forms Builder welcome wizard • Using the Data Block wizard • Using the Layout wizard

Modifying forms with wizards Building master-detail block relationships • Using re-entrant wizards • Modifying forms with wizards

Forms Runtime Understanding forms runtime • The default run time menu • Understanding query mode • Understanding row locking • Understanding commit processing

Beginning application development Organizing the developer’s desktop • How you might approach development • Workshop section • Beginning application development

Forms Builder interface – the Object Navigator Using the Object Navigator • The edit menu • The view menu • The program menu • The tools menu

Forms Builder interface – the Property Palette and status line

The LOV wizard Using the LOV (list of values) wizard • Invoking the LOV at runtime

The Layout Editor What is the layout editor? • Concepts within the layout editor • Using the tool palette • The edit menu • The view menu • The layout menu

The file and help menus

Building text and display items What are items? • Using text items • Using calculation text items • Using display items

Building forms GUI items What are GUI items? • Using check boxes • Using radio groups and radio buttons • Using list items • Using buttons • Using image items

Introduction to client-side triggers Understanding client-side triggers • Using the PL/SQL editor

Building modules and data blocks

Building relations and visual attributes

Building other form objects Building alerts • Building LOVs and record groups • Building editors • Building parameters

Building canvases, frames and windows

Building custom menus Understanding the menu bar • Menu module objects • Menu item types • The menu editor • Creating a menu bar the easy way • Menu item properties • Menu item properties • Menu module properties • Menu submenu properties • Attaching a menu to a form

Advanced menu concepts

The report wizard

The form compiler

The main application form

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today