Answer / Amit Mukherjee

A Before Trigger in SQL and PLSQL is a database object that is executed before an INSERT, UPDATE, or DELETE statement affecting a specific table. It allows developers to perform actions like validating data, setting default values, or enforcing business rules before the actual DML operation takes place.

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

when MSQL8.0 is in market

1 Answers  

---

What is cte sql?

1 Answers  

---

Why select is used in sql?

1 Answers  

---

How do I start sql profiler?

1 Answers  

---

what is a record in a database ? : Sql dba

1 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

What is write ahead logging in sql server?

1 Answers  

---

what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,

---

Explain exception handling in pl/sql?

1 Answers  

---