Answer / Anuj Mishra

A trigger in SQL is a database object that automatically reacts to specific events on a particular table. It's used to enforce data integrity rules, implement complex business logic, and audit database changes.

What is the difference between database trigger and stored procedure?

1 Answers  

---

Can we alter stored procedure?

1 Answers  

---

What is sql query optimization?

1 Answers  

---

What is the difference between functions, procedures, and packages in pl/sql?

1 Answers  

---

What is sp_helptext?

1 Answers  

---

What is the best sql course?

0 Answers  

---

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

---

What is the use of %rowtype?

1 Answers  

---

How do you drop a trigger?

1 Answers  

---

Why stored procedures are faster than query?

1 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

what is bdb (berkeleydb)? : Sql dba

1 Answers  

---