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

what is union, minus and interact commands? : Sql dba

1185

---

What are sql indexes?

997

---

how to return query output in html format? : Sql dba

1073

---

What are different types of functions in sql?

1004

---

can sql servers linked to other servers like oracle? : Sql dba

1005

---

What is execution plan in sql?

1041

---

Is inner join same as self join?

1111

---

What are the usages of sql?

1056

---

What is view? Can we update view

1434

---

Does inner join remove duplicates?

937

---

what is sql? : Sql dba

1023

---

Define overloaded procedure?

1077

---

Is pl sql a scripting language?

1026

---

Does varchar need length?

991

---

What is set serveroutput on?

1131

---