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;

how do you control the max size of a heap table? : Sql dba

0 Answers  

---

What plvcmt and plvrb does in pl/sql?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

How do you delete data from a table?

0 Answers  

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

what is definer rights invoke rights?

1 Answers  

---

full outer join syntax

5 Answers  

---

What is sql lookup?

0 Answers  

---

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---