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;
/

How do we get field detail of a table?

0 Answers  

---

How are extents allocated to a segment?

0 Answers  

---

State all possible different index configurations a table can possibly have?

0 Answers  

---

Explain the use of compress option in exp command.

0 Answers  

---

Is oracle a programming language?

0 Answers  

---

how to store only time in a data base table

2 Answers  

---

can we pass two out parameters at a time in function?please answer to my question

3 Answers   Wipro,

---

What are the different types of databases?

1 Answers  

---

How to write date and time interval literals in oracle?

0 Answers  

---

what is the use of ondelete cascade?

3 Answers  

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

How to delete an existing row from a table in oracle?

0 Answers  

---