Answer Posted / nashiinformaticssolutions

A trigger is a block of PL/SQL code automatically executed in response to certain events (e.g., INSERT, UPDATE, DELETE) on a table.
Example Trigger:
CREATE OR REPLACE TRIGGER EmployeeAudit
AFTER INSERT ON employees
FOR EACH ROW
BEGIN
INSERT INTO audit_log(employee_id, action, action_date)
VALUES (:NEW.id, 'INSERT', SYSDATE);
END;

What is assignment operator in pl sql?

970

---

How do I truncate a sql log file?

1007

---

What is audit logout in sql profiler?

979

---

Can a foreign key be a duplicate?

858

---

What is rowid in sql?

909

---

What is the difference between alter trigger and drop trigger statements?

1044

---

How to change sql*plus system settings?

997

---

How do I install microsoft sql?

984

---

Explain the uses of database trigger.

1055

---

What is db journal file?

956

---

how to calculate expressions with sql statements? : Sql dba

985

---

What is identity column in sql server?

988

---

What is the difference between nested table and varray?

944

---

How to run sql commands in sql*plus?

1081

---

Can one improve the performance of sql*loader? : aql loader

983

---