Answer Posted / barick prabhudatta

List because LOV stands for list of values

After creating a LOV you have to write a trigger

example:
trigger-when-mouse-doubleclick

list_values;

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

639

---

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

2472

---

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

1298

---

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

568

---

What is an SQL FORMS ?

2317

---

---

What is a canvas in oracle forms?

602

---

how do u place it in required folder

1483

---

i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output

1573

---

what is a package n what r the packages availbla in report

1626

---

how do u compile a form i.e .fmb file in Unix or in dos

4030

---

Is it possible to execute a dynamic sql from forms?

612

---

how to send file attachment from oracle forms

2145

---

What is the difference between flex mode and confined mode?

536

---

if some data is not transfered where it will get stored

1468

---

What is a user exit program in oracle reports?

584

---