How to create LOV in Oracle forms?
- 2 Answers
- 31951 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
Why oracle forms required?
can you convert or reverse engineer a fmx back to a fmb file?
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 difference between group above and group left report
What is a canvas in oracle forms?
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE
what is tripstop report?
difference between global n context sensitive segments?
List out the oracle forms configuration files?
how do u compile a form i.e .fmb file in Unix or in dos
How can we generate report output in excel format?
Is it possible to execute a dynamic sql from forms?
What do we mean by record group in oracle forms?
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??
did u received a single file or multiple files
