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;

How to use boolean type in select statement?

993

---

What is a unique constraint?

1011

---

What is foreign key in sql with example?

890

---

How to Execute a Package in PL/SQL.?

1108

---

Can we join tables without foreign key?

907

---

What is the function that is used to transfer a pl/sql table log to a database table?

950

---

How to disable a trigger name update_salary?

1195

---

What is compilation error in pl sql?

920

---

Explain the insert into statements in sql?

935

---

What is Collation Sensitivity ? What are the various type ?

903

---

Is it possible for a table to have more than one foreign key?

976

---

What are the parts of a sql statement?

1027

---

What steps server process has to take to execute an update statement?

919

---

What is the difference between a query and a report?

900

---

What is scalar data type in pl sql?

1018

---