Answer / nilesh

There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS

Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE

and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)

ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

Answer / biswajit biswal

We can specified 28 Database triggers on a single table.

Before Row level insert
After Statement level update
Delete
insert or update
update or delete
insert or delete
insert or update or delete

2*2*7=28

How do I sort a table in sql?

0 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

What does inner join mean?

0 Answers  

---

What is output spooling in sql*plus?

0 Answers  

---

How do I run a script in sql developer?

0 Answers  

---

What is data abstraction in sql?

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

What is hibernate and its relation to sql?

0 Answers  

---

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

What is pl sql architecture?

0 Answers  

---