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

What is a primary key? Explain

1021

---

Why should I use postgresql?

1068

---

What are the popular database management systems in the it industry?

1035

---

What is sql exception?

1012

---

What is the difference between python and sql?

1051

---

What is the difference between nvl function, ifnull function, and isnull function?

1153

---

What are data types in pl sql?

1195

---

What are the types of variables use in pl sql?

1083

---

What is pl sql code?

1104

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1630

---

Define tables and fields in a database

1176

---

What is crud stand for?

1048

---

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

988

---

How do you remove duplicate records from a table?

978

---

What is use of trigger?

985

---