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)

if i want to change the functionality of a item in report during runtime how like what do u write in when_button_pressed

1840

---

What is an implicit anchor and how is it a different form explicit anchor in a report builder?

1089

---

what exactly u write in when_new_form_instance

3378

---

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

2065

---

Name the different triggers associated with oracle forms having a master-detail relationship.

920

---

what are the oracle forms services components include?

959

---

What is a matrix report and how many minimum groups are required to prepare the same?

1060

---

did u received a single file or multiple files

1971

---

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

2136

---

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

1850

---

why the Ctl file u put only in bin folder why not in other folder

1993

---

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

1624

---

if some data is not transfered where it will get stored

1884

---

What is the difference between BPA AND Contract What are documents and test cases u followed

2327

---

Can we invoke one form from another in a multi-forms application?

1069

---