Answer Posted / madhuri

Triggers are basically PL/SQL procedures that are associated
with tables, and are fired whenever a certain modification
(event) occurs. The modification statements may include
INSERT, UPDATE, and DELETE.

The general structure of triggers is:
CREATE [OR REPLACE]TRIGGER trigger_name
BEFORE/AFTER
INSERT/UPDATE/DELETE ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
...
END;

what is the difference between blob and text? : Sql dba

1021

---

What is crud diagram?

949

---

Can we call a function containing dml statements in a select query?

980

---

What are tables and fields in the database?

1112

---

how does a local variable is defined using t-sql? : Transact sql

1018

---

How do I save the results of sql query in a file?

979

---

what is the functionality of the function htmlentities? : Sql dba

966

---

what is text? : Sql dba

1073

---

What is a sql instance vs database?

1117

---

Can instead of triggers be used to fire once for each statement on a view?

962

---

Can %notfound return null after a fetch?

1060

---

Why triggers are used?

990

---

Does truncate table reset auto increment?

994

---

Can we insert in sql function?

1089

---

Does sqlite need a server?

1053

---