Answer Posted / sarat

There are 4 types of Triggers

# Row Triggers and Statement Triggers
# BEFORE and AFTER Triggers
# INSTEAD OF Triggers
# Triggers on System Events and User Events

A row trigger is fired each time the table is affected by
the triggering statement. A statement trigger is fired once
on behalf of the triggering statement.

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

INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE).

How to set up sql*plus output format in oracle?

1038

---

What is over () in sql?

966

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

972

---

What is case function?

1042

---

Who developed sql?

1049

---

Are views faster than queries?

992

---

Why coalesce is used in sql?

1013

---

What is pl sql block in dbms?

1006

---

Is not equal in sql?

1014

---

What does the hierarchical profiler does?

1059

---

What is the least restrictive isolation level? : Transact sql

1069

---

How do I kill a query in postgresql?

1130

---

How do we use distinct statement? What is its use?

1032

---

How many sectors are in a partition?

1076

---

What's the difference between a primary key and a clustered index?

986

---