Answer / Amit Kumar Attari

Triggers are SQL routines that automatically execute in response to specific events on a table. These events include INSERT, UPDATE, or DELETE operations. Triggers are useful for maintaining data integrity, enforcing business rules, and auditing changes.

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

In what condition is it good to disable a trigger?

1 Answers  

---

How to look at the current sql*plus system settings?

1 Answers  

---

What is difference between hql and native sql?

1 Answers  

---

What is the difference between delete and truncate statement in sql?

1 Answers  

---

Is hadoop a nosql?

1 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What is sql procedures and functions?

1 Answers  

---

What is trigger and how to use it in sql?

1 Answers  

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1 Answers  

---

What is an intersect?

1 Answers  

---

what does the t-sql command ident_current does? : Transact sql

1 Answers  

---