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 the built_in routine used to count the no of rows in a group?
What is the use of transactional triggers?
what is integrity n how many integrity rules r there?
Can you attach an lov to a field at design time?
What is a Query Record Group?
What is the "LOV of Validation" Property of an item? What is the use of it?
What is a predefined exception available in forms 4.0?
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
Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through
How can I sum column wise in Oracle excel report?
What is the frame & repeating frame?
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.