Two triggers one is before insert and other is after insert are firing on a ta

Two triggers one is before insert and other is after insert
are firing on a table.If 10 times you insert in a table.Then
how many times before trigger and how many types after trigger
will fire in pl/sql.

Question Posted / anuska4010

1 Answers
4046 Views
I also Faced
E-Mail Answers

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you ..

Answer / siva prasad

both will be fired 10 times

Is This Answer Correct ?

8 Yes

0 No

Post New Answer

More Oracle General Interview Questions

What is the difference between column level constraints and table level constraints?

14 Answers IBM, TCS,

How to call a sub procedure?

0 Answers

How to convert characters to numbers in oracle?

0 Answers

find out the second highest salary?

55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,

What is hash cluster in oracle?

0 Answers

can u plz provide me oca sql dumps please i need them

0 Answers

List the various oracle database objects?

0 Answers

What is format trigger?

0 Answers

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

0 Answers

What is save point in oracle database?

0 Answers

What is autonomous transaction?

6 Answers

How to call a trigger inside a stored procedure?Give an example.

2 Answers

For more Oracle General Interview Questions Click Here