How to create LOV in Oracle forms?
Answers were Sorted based on User's Feedback
Answer / 147037
Click the LOV icon in the object navigator and choose ur
option of a manual or wizard .
A record group will be authomatically created depending on
the LOV.
| Is This Answer Correct ? | 79 Yes | 46 No |
Answer / pranita kochar
In the ‘Object Navigator’ window, select the LOVs object known as "List of values."
Then click on the green ‘+’ (Create) icon. In the ‘New List Of Value’ window, leave the default radio button which is: ‘Use the LOV Wizard’ and the click ‘OK.’
LOVs get their data from Record Groups, which may be populated using SQL queries, or by entering a static list of values. In the LOV Wizard window, use the default to base your LOV on a new Record Group; and then click ‘Next.’
In the ‘SQL Query Statement’ box, write a ‘SQL’ statement to query customers name and their ID. Then click ‘Next.’
(SQL Query Statement)
| Is This Answer Correct ? | 15 Yes | 8 No |
What are the types of calculated columns available?
Do user parameters appear in the data modal editor in 2.5?
What are the various methods of performing a calculation in a report ?
How can a square be drawn in the layout editor of the report writer?
What is the difference between BPA AND Contract What are documents and test cases u followed
how to pass 2 variables from one form to other form
What is a Non Query Record Group?
what is the difference between oracle reports 6i and oracle reports 10g? give atleast 10 differences? (plz give the answer vvvvvvvvvvv.urgent)
running a report from Form or other Report , The Parameter Form Page will be Display first . I don?t want to display the screen . What I have to do ?
What is the basic data structure that is required for creating an LOV?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the smae block level ?
How is link tool operation different between reports 2 & 2.5?