Answer / 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;

Answer / 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;

Answer / hr@tgksolutions.com

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;

Talk about views

10 Answers   Polaris,

---

How is data stored on a disk?

0 Answers  

---

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

0 Answers  

---

What is the use of function in sql?

0 Answers  

---

what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  

---

How does stored procedure reduce network traffic?

0 Answers  

---

What is the difference between instead of trigger and after trigger?

0 Answers  

---

Types of optimization?

6 Answers   Microsoft,

---

Which table is left in join?

0 Answers  

---

What is compound trigger?

0 Answers  

---

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

---

What is latest version of sql?

0 Answers  

---