Answer Posted / arpit gautam

There are two types of triggers:

1.Row Triggers and Statement Triggers

A row trigger is fired each time the table is affected by
the triggering statement. For example, if an UPDATE
statement updates multiple rows of a table, a row trigger
is fired once for each row affected by the UPDATE
statement. If a triggering statement affects no rows, a row
trigger is not run.

A statement trigger is fired once on behalf of the
triggering statement, regardless of the number of rows in
the table that the triggering statement affects, even if no
rows are affected. For example, if a DELETE statement
deletes several rows from a table, a statement-level DELETE
trigger is fired only once.


2.BEFORE and AFTER Triggers

BEFORE triggers run the trigger action before the
triggering statement is run.

AFTER triggers run the trigger action after the triggering
statement is run.

Trigger Type Combinations
a. BEFORE statement trigger

b.BEFORE row trigger

c.AFTER statement trigger

d.AFTER row trigger


3.INSTEAD OF Triggers

INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE). These triggers are
called INSTEAD OF triggers because, unlike other types of
triggers, Oracle fires the trigger instead of executing the
triggering statement.

4.Triggers on System Events and User Events

System events

Database startup and shutdown

Data Guard role transitions

Server error message events

User events

User logon and logoff

DDL statements (CREATE, ALTER, and DROP)

DML statements (INSERT, DELETE, and UPDATE)

how to convert numeric values to character strings? : Sql dba

1157

---

what are the drivers in mysql? : Sql dba

1059

---

How many subqueries can be nested in a statement?

1039

---

Does postgresql run on the cloud?

1222

---

What is full join?

1019

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1490

---

What is PL/SQL Records?

1253

---

What are stuff and replace function?

1141

---

What is materialized view in sql?

958

---

Difference between global and parameter variables?

2013

---

What are primary key and foreign key and how they work?

1016

---

Could you please provide oca (oracle 10g) dumps for my certification ?

5241

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1018

---

Explain what is sql?

1180

---

Write a sql query to convert all character to uppercase after hypen.

1484

---