Answer / manikandan. s

triggers can't be called. They will be fired automatically
during certain operations like insert, delete, etc..

Inside a trigger we can call function

Ex

CREATE OR REPLACE FUNCTION f_t RETURN NUMBER IS
tmpVar NUMBER;
BEGIN
select sum(col2) into tmpVar from t;
RETURN tmpVar;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
RAISE;
END f_t;
/

CREATE OR REPLACE TRIGGER L4OC.T_T
AFTER INSERT
ON L4OC.T
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
declare
tmpvar number;
begin
select f_t into tmpvar from dual;
insert into t_t values(:old.col1, tmpvar);
end;
/

Give the constructs of a package, function or a procedure.

0 Answers  

---

What are Schema Objects ?

2 Answers  

---

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

6 Answers   Mind Tree,

---

What are the different types of database objects?

0 Answers  

---

Explain integrity constraints?

0 Answers  

---

How to recover a dropped table in oracle?

0 Answers  

---

What is oracle thin client?

0 Answers  

---

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers   Verizon,

---

Explain an exception and its types?

0 Answers  

---

How to create a single index for multiple columns?

0 Answers  

---

how to see the data (in unix) using dataset in datastage?

1 Answers   iGate,

---

is database gud carrier option??

1 Answers  

---