Answer Posted / sandeep chawdekar

there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger

dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing

instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs

system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level

How do I edit a stored procedure?

988

---

what are all the different types of indexes? : Sql dba

1046

---

Why is sql better than hql?

981

---

What is the purpose of cursors in pl/sql?

1134

---

explain the difference between myisam static and myisam dynamic. : Sql dba

944

---

How do you take the union of two tables in sql?

981

---

how to write date and time literals? : Sql dba

957

---

What is the difference between sql, mysql and sql server?

1097

---

How do you write a complex sql query?

1057

---

How to display the records between two range in Oracle SQL Plus?

1143

---

What is snowflake sql?

1069

---

What is the difference between local variables and global variables?

1122

---

Can you call pl/sql package functions from within a fast formula?

1033

---

What plvcmt and plvrb does in pl/sql?

1316

---

What is the use of function in sql?

1089

---