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
In what situation u create the BPA.
Can we invoke one form from another in a multi-forms application?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
What do you understand by oracle forms and why are they required?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
did u received a single file or multiple files
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 are the new features introduced in oracle form services in 11g release 2?
Is it possible to execute a dynamic sql from forms?
what is a package n what r the packages availbla in report
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
all steps of bitmap report?
What is a matrix report and how many minimum groups are required to prepare the same?
what is tripstop report?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??