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

How do I run a sql script?

1121

---

how can we submit a form without a submit button? : Sql dba

964

---

How to get each name only once from an employee table?

1097

---

What is inner join in sql?

1060

---

How many clustered indexes can be created on a table?

1067

---

Define the select into statement.

1038

---

Is truncate ddl or dml?

976

---

Is pl sql better than sql?

1010

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2007

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1110

---

What is db journal file?

1035

---

When to use inner join and left join?

938

---

What is the difference between partitioning and sharding?

990

---

How to load data with sql*loader?

1034

---

How is debugging done?

958

---