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;

Define select, insert, create, delete, update, drop keywords

0 Answers  

---

How do you create a unique index?

0 Answers  

---

what are myisam tables? : Sql dba

0 Answers  

---

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

---

Can we create foreign key without primary key?

0 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---

What is difference between sql function and stored procedure?

0 Answers  

---

How do I save the results of sql query in a file?

0 Answers  

---

How to get help at the sql prompt?

0 Answers  

---

Define concurrency control. : Transact sql

0 Answers  

---

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

2 Answers   CTS,

---

how to get help information from the server? : Sql dba

0 Answers  

---