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
a text item is there what r the different types of triggers associated with it
In what sequence do triggers get fired by oracle forms?
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
What is an oracle report?
What is the difference between bind and lexical parameter?
if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed
Explain how can you use the same lov for 2 columns?
if u want to delete all these detail block etc what will happen in form
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
how do u compile a form i.e .fmb file in Unix or in dos
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
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
can you convert or reverse engineer a fmx back to a fmb file?
What do you understand by lov?
In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?