Downloaded 76 times
Uploaded bySekhar Byna
Oracle Forms Creation-List of Values (LOV)
This document discusses List of Values (LOVs) and editors in Oracle Forms and Applications. It describes how to create and use LOVs, the properties of LOVs, and how to attach LOVs to items. It also covers how to create and use different types of editors to override the default editor for special requirements.
More Related Content
Similar to Oracle Forms Creation-List of Values (LOV)
Oracle Forms Creation-List of Values (LOV)
- 1. Working LOVs andEditors http://ebiztechnics.blogspot.com
- 2. Objectives • Creating andusing LOVs • Creating and using Editors http://ebiztechnics.blogspot.com
- 3. LOVs • LOVs – Listof values for text items – Dynamic or static list – Independent of single text items – Flexible and efficient • Used for inputting values into Foreign key items. http://ebiztechnics.blogspot.com
- 4. LOVs and RecordGroups Select deptno,dname From dept Record Group LOV Window Dept No http://ebiztechnics.blogspot.com
- 5. Creating and usingLOVs • Select the LOVs node in Object Navigator • Click the create icon. • Use LOV wizard and follow the steps one by one. • Finally click finish to complete. • Attach the LOV to text item: • Go to property pallet of the item to which you would like to attach. • Select the LOV property. • From the list choose the LOV name created by you. • To invoke LOV : Press F9 or Click Edit -> Display List in forms runtime window http://ebiztechnics.blogspot.com
- 6. LOV Properties • Title •Column Mapping Properties • Filter Before Display • Automatic Display • Automatic Refresh • Automatic Select • Automatic Skip • Automatic Position http://ebiztechnics.blogspot.com
- 7. Editors – Override defaulteditor – Used for special requirements such as larger editing window, position, color, and title – System editor available as an option • Types of Editors – Forms Default Editor – System Editor (Default Notepad) – User Defined or Custom Editor. http://ebiztechnics.blogspot.com
- 8.
- 9. Summary • Creating LOVs •Attaching LOVs to items • Properties of LOVs • Creating and using Editors http://ebiztechnics.blogspot.com
- 10. Summary • Creating LOVs •Attaching LOVs to items • Properties of LOVs • Creating and using Editors http://ebiztechnics.blogspot.com
Editor's Notes
- #5 Note: Because LOVs and record groups are separate objects, you can create multiple LOVs based on the same record group.
- #7 Note: More than one LOV can be based on the same record group. When this is the case and you set Automatic Refresh to No, Form Builder will not re-execute the LOV query once any of the LOVs is invoked.