AUDIENCE:   This course is for programmers and developers who need to design applications to access the Oracle database. This course takes students though application development in Developer Forms 10G beginning with basic form design and ending up with fully integrated applications rollout. The integrated workshops are designed to mimic a true application building process. PREREQUISITES:   A good knowledge of SQL and PL/SQL, preferably gained through attendance of a suitable course like our Oracle SQL and PL/SQL courses together with some experience of using these products in an everyday role. Knowledge of the GUI environment would be advantageous. DURATION:   5 days. Hands on. OBJECTIVES:   On completion, delegates will have a good understanding of the Oracle Forms 10G environment and will be able to generate all levels of Forms to access the Oracle database. The course covers the design interface, object navigation and processing, library package integration and external Forms interfaces. COURSE CONTENT:   Developer Overview Developer Reports Developer Forms Other Components of Developer Suite Application development Forms Architecture Forms initialization parameter Client/Server architecture Internet/Intranet architecture Building our Application Creating a master/detail relation Changing layout and properties Adding a stacked canvas Event Triggers Creating triggers Types of triggers Program Units PL/SQL Creating program units Input parameters for procedure Output parameters for procedures I/O parameters for procedures Functions in program units Local procedures and functions Compiling program units Adding Windows Functionality Radio groups Check boxes and list items Buttons & toolbars Visual attributes Editors Alerts Creating application windows About popup menus Record Groups Static record groups Query record groups Dynamic record groups Lists of Values (LOV) Creating an LOV Creating a trigger for our LOV Packages Package structure Package creation Built-in Packages DDE TEXT_IO Design Concepts - Sharing Objects Creating an object group Libraries Property classes Menus Creating A Menu Adding a Menu to a Form Debug How Debug works Forms Applications Workshop Projects: Deliver Web-based application. PI07/01