Oracle10g ODS Forms II Customize Internet Applications

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

• Building client-side triggers and program units to customize forms applications.
• Dynamically controlling form objects and behavior during runtime.
• Taking advantage of built-in functions and procedures.
• Writing efficient and well-tuned client-side logic.
• Integrating multiple Oracle10g modules into enterprise applications.
• Exploiting object-oriented features to maximize reuse of components.
• Specialized techniques such as hierarchical trees, procedure data blocks, and timers.
• Integrating forms logic with database server objects into a cohesive solution

Target audience

The target audience for this course is web application developers and designers, as well as their management, who will be developing and customizing complex 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
• Oracle10g ODS Forms I: Build Internet Applications

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". Following any 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

Developing programs within forms About Oracle10g program development • Understanding client-side triggers • Understanding client-side program units • Understanding built-in subprograms • Understanding PL/SQL libraries

The PL/SQL Editor Understanding PL/SQL Editor concents • Using the PL/SQL Editor • Using the PL/SQL Editor productivity features

The validation triggers Using the validation triggers • Using when-validate item

Understanding built-ins using alerts Understanding built-in concepts • Categories of built-ins • Calling built-in procedures vs functions • Using object ID references • Referencing object properties • Using the alert built-ins

Using the item built-ins Understanding item built-ins • Using general item built-ins • Using navigation item built-ins • Using item built-ions to get and set properties

Speciality item built-ins About specialty item built-ins • Using GUI control items built-ins • Using menu item built-ins • Using image item built-ins

Using built-ins for other functional objects About the functional object built-ins • Using the block built-ins • GET_BLOCK_PROPERTY() and SET_BLOCK_PROPERTY() • TRUE/FALSE properties list • Using the record built-ins • Using the LOV built-ins • Using the editor built-ins • Using the relation built-ins • About restricted built-ins

Using application and module built-ins About the application and form built-ins • Using the application built-ins • Using the form built-ins

Specialized programming techniques About the techniques • Using system variables • Using global variables • Using indirect references

Intermediate-level triggers and built-ins About intermediate-level trigger categories • Using end user action triggers • Using navigational triggers • Using Query triggers and built-ins • Using block processing triggers • Using key triggers and built-ins

Dynamic control over visual objects Working with visual objects • Using the window built-ins and triggers • Using the canvas built-ins

Error customization

Advanced forms customization About record groups and dynamic lists • Using record groups • Using dynamic lists

Applications with multiple modules About multiple modules and parameter lists • Calling form module built-ins

Object orientation, property classes Understanding object orientation concepts • Obtaining inheritance with property ckasses

Object orientation, building reusable components About reusable components • Obtaining inheritance with objects • Using object groups • Using object libraries

Object orientation, writing reusable logic Understanding advanced object principles • Object orientation with packages • Object orientation with PL/SQL libraries

Integrating server-side logic Accessing database server-side logic • Integrating database constraints • Integrating database procedures • Integrating database triggers

Building stored procedure data blocks Choosing the data block source • Implementing stored procedure data blocks

Hierarchical trees What are hierachical trees? • Creating the hierarchical tree • Populating the tree with data • Hierarchical tree triggers and system variables • Using FTREE() and hierarchical tree built-ins • ADD_TREE_DATA()• ADD_TREE_NODE()• DELETE_TREE_NODE()• GET_TREE_NODE_PARENT()• GET_TREE_NODE_PROPERTY()• GET_TREE_PROPERTY()• GET_TREE_SELECTION()• POPULATE_GROUP_FROM_TREE()• POPULATE_TREE()• SET_TREE_NODE_PROPERTY()• SET_TREE_PROPERTY()• SET_TREE_SELECTION()• FIND_TREE_NODE()

Database server processing

Timers

Updating the main application

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