Answer Posted / arun raj

u can define a trigger
1. For Each Row
2. For Each Statement

You can have the following triggers defined for the above
two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE

So it makes a total of 12.

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

1698

---

Is it possible to have multiple layouts in a report?

1029

---

Name the different triggers supported by oracle reports and their firing order.

1092

---

What is the difference between flex mode and confined mode?

1055

---

What is an oracle report? List its various types.

976

---

What do you understand by oracle forms?

1048

---

What are the various configuration files that are used by oracle forms?

1034

---

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

1898

---

Explain how one can iterate through items and records in a specified block?

1140

---

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

2288

---

What do you understand by lov?

1038

---

all steps of bitmap report?

2355

---

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

1907

---

What is a canvas in oracle forms?

1066

---

how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g

1979

---