Answer Posted / glibwaresoftsolutions

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 sql profiler? : Sql dba

1024

---

Is sql a programming?

962

---

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

1092

---

What is mutating error in pl sql?

1002

---

Can you upgrade sql express to full sql?

1044

---

What are sql constraints?

1159

---

What is group by in sql?

1074

---

Can we rollback after truncate?

1013

---

What is full join in sql?

973

---

What is difference between sql function and stored procedure?

989

---

Is sqlite good enough for production?

982

---

What does subquery mean in sql?

1035

---

How do I use google cloud in sql?

1069

---

How does rowid help in running a query faster?

1402

---

Does view contain data?

1016

---