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 data profiling in sql?

1057

---

What does closing a cursor do?

1303

---

Can a foreign key be null?

1069

---

How do I count duplicates in sql?

1085

---

Why do we need sharding?

978

---

What does where 1 1 mean in sql?

1020

---

Explain the difference between drop and truncate commands in sql?

1022

---

Why cross join is used?

1061

---

What is scope of pl sql developer in future?

993

---

What is basic structure of pl sql?

1050

---

What is java sql drivermanager?

1067

---

What is data manipulation language?

1174

---

Define commit, rollback and savepoint?

1016

---

How many commands are there in sql?

1010

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

956

---