How to create LOV in Oracle forms?

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


Please Help Members By Posting Answers For Below Questions

In what situation u create the BPA.

1994


Can we invoke one form from another in a multi-forms application?

907


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

2083


What do you understand by oracle forms and why are they required?

800


how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1769


did u received a single file or multiple files

1815


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

1501


what are the new features introduced in oracle form services in 11g release 2?

829


Is it possible to execute a dynamic sql from forms?

831


what is a package n what r the packages availbla in report

1880


if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1709


all steps of bitmap report?

2136


What is a matrix report and how many minimum groups are required to prepare the same?

852


what is tripstop report?

1571


HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

1297