How to create LOV in Oracle forms?

Answers were Sorted based on User's Feedback



How to create LOV in Oracle forms?..

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

How to create LOV in Oracle forms?..

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

Post New Answer

More Oracle Forms Reports Interview Questions

What is the built_in routine used to count the no of rows in a group?

1 Answers  


What is the use of transactional triggers?

1 Answers  


what is integrity n how many integrity rules r there?

2 Answers   Convergys,


Can you attach an lov to a field at design time?

1 Answers  


What is a Query Record Group?

1 Answers  






What is the "LOV of Validation" Property of an item? What is the use of it?

1 Answers  


What is a predefined exception available in forms 4.0?

1 Answers  


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

5 Answers  


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

1 Answers   Azri Solutions,


How can I sum column wise in Oracle excel report?

1 Answers  


What is the frame & repeating frame?

1 Answers  


In workflow how can we send a notification to the Supplier giving the Corresponding report Details.

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)