How to create LOV in Oracle forms?
- 2 Answers
- 32725 Views
- Accenture, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how do u compile a form i.e .fmb file in Unix or in dos
in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement
what is tripstop report?
What is a matrix report and how many minimum groups are required to prepare the same?
What is an oracle report? List its various types.
What do we mean by record group in oracle forms?
Explain how one can iterate through items and records in a specified block?
all steps of bitmap report?
Is it possible to execute a dynamic sql from forms?
Name the different triggers associated with oracle forms having a master-detail relationship.
What do you understand by oracle forms?
What is the difference between bind and lexical parameter?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
What is a canvas in oracle forms?
What do you understand by lov?
