Training
Provided by 123-CBT Computer Based Training
Course Overview This course is the fifth in a six-part Oracle Developer series based on Oracle Developer Release 6. This course enables learners to create Key triggers, to write code that responds to mouse events, to manage windows and canvases, and to use the Object Navigator. In addition, learners work with multiple form applications, record groups, and list items. Learn To: - Identify the rules, types, and functions of Key triggers.
- Create a Key trigger and write the code that associates the key triggers with the user interface.
- Write code that responds to mouse events.
- Write the code to manage windows and canvases by using built-ins and triggers.
- Invoke multiple forms by using built-ins and pass data between forms by using parameter lists.
- Work with record groups.
- Control list items at design time and programmatically by using built-in functions.
Content Emphasis Skills-Based Audience Application developers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL: Database Programming (60131). In addition, learners should have taken the first four parts of the Oracle Developer series: Oracle Developer: Forms Fundamentals (62211); Oracle Developer: Enhancing the User Interface (62212); Oracle Developer: Writing and Debugging Code (62213); and, Oracle Developer: Project Builder and Menu Modules (62214). Total Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Key Triggers and Mouse Events Duration: 1 - 2 Hour(s) - Match the types of Key triggers with their descriptions.
- Identify the uses of Key triggers in a form module.
- Identify the rules for defining Key triggers.
- Create a Key trigger in a form module by using the PL/SQL Editor.
- Associate a built-in with the DO_KEY built-in by using the PL/SQL Editor.
- Match the mouse related triggers with their events.
- Create a mouse movement trigger by using the PL/SQL Editor.
- Create a mouse button action trigger for a given task by using the PL/SQL Editor.
- Match the mouse system variables with their uses.
- Identify the guidelines to follow while implementing the drag-and-drop functionality.
Unit 2: Window and Canvas: Runtime Management Duration: 1 - 2 Hour(s) - Match the window-interaction triggers with their functions.
- Match the built-ins used for manipulating windows with their functions.
- Write the code to change the appearance of a window in a form by using built-ins.
- Write the code to display multiple windows at specified positions in a form by using built-ins.
- Write the code to close a window by using built-ins.
- Identify the characteristics of windows and blocks in a form.
- Match the built-ins for manipulating canvases with their functions.
- Write the code to manipulate tab-style canvases by using built-ins.
Unit 3: Working with Multiple Form Applications Duration: 2 Hour(s) - Identify the behavior of a multiple form application.
- Identify the methods to share information between multiple forms.
- Identify the built-ins used to programmatically invoke another form.
- Match the different methods of invoking forms with the tasks they enable you to perform.
- Write the code to invoke a form in a modeless fashion by using built-ins.
- Write the code to perform a query at forms startup by using triggers.
- Match the built-ins for navigating forms with their descriptions.
- Identify the features of transaction processing for Opened Forms.
- Write the code to invoke a form in a modal fashion from an open form by using built-ins.
- Modify the default functionality of transaction processing for called forms by using the PL/SQL Editor.
- Write the code to invoke a new form on exiting the current form by using built-ins.
- Identify the restrictions on using OPEN_FORM with CALL_FORM.
- Match the different methods of invoking forms with the tasks they enable you to perform.
- Create a form parameter by using the Object Navigator.
- Write the code to pass data among forms by using parameter lists.
- Write the code to close a form by using the CLOSE_FORM built-in.
- Write the code to close a form by using the EXIT_FORM built-in.
Unit 4: Record Groups and List Items Duration: 2 Hour(s) - Identify the uses of record groups.
- Match the record group types with their functionality.
- Create a query record group at design time by using the Object Navigator.
- Create a static record group at design time by using the Object Navigator.
- Modify a record group at design time by using the Property Palette.
- Match the built-ins used to manage the record group structures with their functionality.
- Identify the built-ins used to manage the data in record groups.
- Define a query record group by using built-ins.
- Define a non-query record group by using built-ins.
- Match the built-ins used to process record group rows with their functionality.
- Write the code to manipulate record group rows by using built-ins.
- Write the code to manipulate selected record group rows by using built-ins.
- Identify the built-ins used for manipulating list items.
- Write the code to implement dynamic list items by using built-ins.
- Write the code to add values to a combo box list item at run time by using built-ins.
Training Avaliability and Delivery
| This is primarily online training |  | This is an online eLearning or CBT training program |  | This program may be available on CD |  | Contact 123-CBT Computer Based Training for more information |
|
| Training Presented in: | English |
|
Related Keywords:
oracle developer r6 6i
databases enterprise
oracle
information technology
cd web
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
More Oracle Developer R6 6i Training from 123-CBT Computer Based Training
Click here for more information or to take this course
| 
