Interested to Buy Any Domain ? << Click Here >> for more details...
Can we call a trigger inside a function and function inside a
trigger? Give example.
- 1 Answers
- 14382 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / 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;
/
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
How to select some columns from a table in oracle?
What is an anonymous block?
How to create a new user account in oracle?
What is dynamic proxy?
What do you mean by a tablespace?
How can I introduce multiple conditions in like operator?
query optmization techniques and quwry analyser+projects+ppts
How to initialize variables with default values?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is system tablespace?
What happens to the indexes if a table is recovered?
What is meant by raw datatype?
How to do paging with oracle?
How do we create privileges in oracle?
What is a tns service name?
