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;

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

what is an associative array with example?

1 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

Does inner join return duplicate rows?

0 Answers  

---

Is there a 64 bit version of ssms?

0 Answers  

---

How do I order by ascending in sql?

0 Answers  

---

What is a nested table in word?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

what are Dynamic SQL statements?

9 Answers  

---

Is oracle sql free?

0 Answers  

---

What is localdb mssqllocaldb?

0 Answers  

---