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 count rows in sql?

1003

---

How many rows can sqlite handle?

1112

---

Why is pl sql used?

980

---

What is a boolean in sql?

980

---

how many triggers are allowed in mysql table? : Sql dba

1071

---

What is auto increment feature in sql?

1122

---

How do I remove duplicates in two columns?

1065

---

What is the difference between a procedure and a function?

1111

---

how do you login to mysql using unix shell? : Sql dba

1080

---

Is sql free?

967

---

Is foreign key mandatory?

1002

---

How does a covering index work?

960

---

How do I count duplicates in sql?

1105

---

what are the types of subquery? : Sql dba

1105

---

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

1438

---