Oracle 11g Developer 2 x 12 days 24 Hrs Rs. 10,000
Prerequisites : Before entering the program, students should have a working knowledge of spreadsheet software (Excel preferred). Intermediate, Graduates/I.T. prerequisite by successfully completing the prior studies.
CHAPTER 1: INTRODUCING ORACLE FORMS DEVELOPER AND FORMS SERVICES : Oracle 10g Products
1 – ·         Oracle Application Server Architecture
2 – ·         Oracle Forms Services Architecture
3 – ·         Benefits and Components of Oracle Developer Suite
4 – ·         Running a Forms Developer Application
CHAPTER 2: CREATING FORMS MODULES
1 – ·         Creating a Basic Forms Module
2 – ·         Creating a Master-Detail Forms Module
3 – ·         Modifying the Data Block
4 – ·         Modifying the Layout
CHAPTER 3: WORKING WITH DATA BLOCKS AND FRAMES
1 – ·         Using the Property Palette
2 – ·         Managing Object Properties
3 – ·         Creating and Using Visual Attributes
4 – ·         Controlling the Behavior and Appearance of Data Blocks
5 – ·         Controlling Frame Properties
6 – ·         Creating Control Blocks
7 – ·         Deleting Data Blocks
CHAPTER 4: WORKING WITH INPUT ITEMS
1 – ·         Creating Text Items
2 – ·         Controlling the Behavior and Appearance of Text Items
3 – ·         Creating LOVs
4 – ·         Defining Editors
5 – ·         Creating Check Boxes
6 – ·         Creating List Items
7 – ·         Creating Radio Groups
CHAPTER 5: WORKING WITH NON INPUT ITEMS
1 – ·         Creating a Display Item
2 – ·         Creating an Image Item
3 – ·         Creating a Push Button
4 – ·         Creating a Calculated Item
5 – ·         Creating a Hierarchical Tree Item
6 – ·         Creating a Bean Area Item
 CHAPTER 6: CREATING WINDOWS AND CANVASES
1 – ·         Overview of Windows and Canvases
2 – ·         Displaying a Form Module in Multiple Windows
3 – ·         Creating a New Window
4 – ·         Displaying a Form Module on Multiple Layouts
5 – ·         Creating a New Content Canvas
6 – ·         Creating a Stacked Canvas
7 – ·         Creating a Toolbar
8 – ·         Creating a Tab Canvas
CHAPTER 7: PRODUCING TRIGGERS
1 – ·         Defining Trigger Components: Type, Code, and Scope
2 – ·         Specifying Execution Hierarchy
3 – ·         Using the PL/SQL Editor
4 – ·         Using the Database Trigger Editor
5 – ·         Writing Trigger Code
6 – ·         Using Variables and Built-ins
7 –                ·       Using the When-Button-Pressed and When-Window-Closed Triggers
CHAPTER 8: DEBUGGING TRIGGERS
1 – ·         The Debugging Process
2 – ·         The Debug Console
3 – ·         Setting Breakpoints
4 – ·         Debugging Tips
5 – ·         Running a Form in Debug Mode
6 – ·         Stepping through Code
CHAPTER 9: ADDING FUNCTIONALITY TO ITEMS
1 – ·         Coding Item Interaction Triggers
2 – ·         Defining Functionality for Check Boxes
3 – ·         Changing List Items at Run Time
4 – ·         Displaying LOVs from Buttons
5 – ·         Populating Image Items
6 – ·         Populating and Displaying Hierarchical Trees
7 – ·         Interacting with JavaBeans
CHAPTER 10: RUN-TIME MESSAGES AND ALERTS
1 – ·         Built-Ins and Handling Errors
2 – ·         Controlling System Messages
3 – ·         The FORM_TRIGGER_FAILURE Exception
4 – ·         Using Triggers to Intercept System Messages
5 – ·         Creating and Controlling Alerts
6 – ·         Handling Server Errors
CHAPTER 11: QUERY TRIGGERS
1 – ·         Handling Server Errors
2 – ·         SELECT Statements Issued During Query Processing
3 – ·         WHERE and ORDER BY clauses and the ONETIME_WHERE property
4 – ·         Writing Query Triggers
5 – ·         Query Array Processing
6 – ·         Coding Triggers for Enter-Query Mode
7 – ·         Overriding Default Query Processing
CHAPTER 12: VALIDATION
1 – ·         Validation Process
2 – ·         Controlling Validation Using Properties
3 – ·         Controlling Validation Using Triggers
4 – ·         Performing Client-Side Validation with PJCs
5 – ·         Tracking Validation Status
6 – ·         Using Built-ins to Control When Validation Occurs
CHAPTER 13: NAVIGATION
1 – ·         Navigation Overview
2 – ·         Understanding Internal Navigation
3 – ·         Using Object Properties to Control Navigation
4 – ·         Writing Navigation Triggers: When-New–Instance, Pre- and Post- Triggers
5 – ·         The Navigation Trap
6 – ·         Using Navigation Built-Ins in Triggers
CHAPTER 14: TRANSACTION PROCESSING
1 – ·         The Commit Sequence of Events
2 – ·         Characteristics and Common Uses of Commit Triggers
3 – ·         Testing the Results of Trigger DML
4 – ·         DML Statements Issued during Commit Processing
5 – ·         Overriding Default Transaction Processing
6 – ·         Running against Data Sources Other Than Oracle
7 – ·         Getting and Setting the Commit Status
8 – ·         Implementing Array DML
CHAPTER 15: WRITING FLEXIBLE CODE
1 – ·         What is Flexible Code?
2 – ·         Using System Variables for Flexible Coding
3 – ·         Using Built-in Subprograms for Flexible Coding
4 – ·         Referencing Objects by Internal ID
5 – ·         Referencing Items Indirectly
CHAPTER 16: SHARING OBJECTS AND CODE
1 – ·         Benefits of Reusable Objects and Code
2 – ·         Working with Property Classes
3 – ·         Working with Object Groups
4 – ·         Copying and Subclassing Objects and Code
5 – ·         Working with Object Libraries
6 – ·         Working with SmartClasses
7 – ·         Reusing PL/SQL
8 – ·         Working with PL/SQL Libraries
CHAPTER 17: USING WEBUTIL TO INTERACT WITH THE CLIENT
1 – ·         Benefits of WebUtil
2 – ·         Integrating WebUtil into a Form
3 – ·         Interacting with the Client
CHAPTER 18: INTRODUCING MULTIPLE FORM APPLICATIONS
1 – ·         Multiple Form Applications Overview
2 – ·         Starting Another Form Module
3 – ·         Defining Multiple Form Functionality
4 – ·         Sharing Data among Modules
5 – ·         ORACLE REPORTS