How to create LOV in Oracle forms?
Answers were Sorted based on User's Feedback
Answer / 147037
Click the LOV icon in the object navigator and choose ur
option of a manual or wizard .
A record group will be authomatically created depending on
the LOV.
| Is This Answer Correct ? | 79 Yes | 46 No |
Answer / 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 |
What is a predefined exception available in forms 4.0?
i created a parameter list in reports. how to restrict that parameter list with parameters
What are the default parameter that appear at run time in the parameter screen?
what is place holder column
Deleting a page removes information about all the fields in that page ?
Can you attach an alert to a field?
i have 9 values in a table i.e -99 -56 -32 41 -2 33 95 -88 55 my question is that i wanna elimenate all -ve values and wann sum of + values in report i m using devsuite 10g its urgent kindly if anyone knows that answer message me the following yahoo id thanx ALI smalipaki@yahoo.com
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
How we can migrate the 6i report to 10g reports. What steps need to reuired?
What are all the system Parameters available in ORACLE Reports
What package procedure is used for calling another form ?
How can you execute the user defined triggers in forms 3.0 ?