Answer Posted / ajaz ahmad

TRIGGER:- when button_pressed

declare
cursor c1 is select colum-name from table-name;
sum table-name%rowtype;
begin
sum := 0;

for z in c1 loop
if z.column-name < 0 then
null;
else
sum := NVL( sum + nvl(z.column-name),0);
end if;
end loop;
message('Sum of +ve Values is ='|| sum);
end;

Explain the different levels at which oracle form services interact.

1006

---

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

4516

---

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

1635

---

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

998

---

List the different types of columns in oracle reports.

940

---

a text item is there what r the different types of triggers associated with it

1945

---

Is it possible to have multiple layouts in a report?

975

---

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

1031

---

In what sequence do triggers get fired by oracle forms?

916

---

how do u place it in required folder

1873

---

what exactly u write in when_new_form_instance

3391

---

if u want to delete all these detail block etc what will happen in form

1932

---

What is an oracle report?

999

---

What is an oracle report? List its various types.

925

---

can you convert or reverse engineer a fmx back to a fmb file?

1099

---