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;

Is not null in sql?

0 Answers  

---

How to remove duplicate rows from a table?.

3 Answers  

---

how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---

What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,

---

What is parameter substitution in sql?

0 Answers  

---

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

---

What is t sql in sql server?

0 Answers  

---

What is blind sql injection?

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

What is a dirty read sql?

0 Answers  

---

How do I make my sql query run faster?

0 Answers  

---