Answer Posted / mohan

Database triggers and Application triggers

In database triggers
(Before, after)
(row level, statement level)
(insert,update,delete)

What mean sql?

576

---

Explain the difference in execution of triggers and stored procedures?

563

---

How do you create an update query?

520

---

Is sql developer case sensitive?

514

---

What are the events on which a database trigger can be based?

592

---

---

Why use truncate instead of delete?

542

---

What are the main features of cursor?

627

---

Is sql workbench free?

528

---

Is it possible to create startup or shutdown trigger for on-schema?

579

---

Why is normalization important?

534

---

What does the base_object_type column shows in the user.triggers data dictionary view?

568

---

What is pl/sql table? Why it is used?

556

---

What are pl/sql packages?

567

---

What is the basic structure of an sql?

567

---

What is embedded sql with example?

542

---