Answer / Shashank Agarwal

Triggers are used to perform specific actions automatically in response to certain events like INSERT, UPDATE or DELETE on a table. This helps maintain data integrity and enforce business rules without requiring manual intervention.

What is the life of an sql statement?

1 Answers  

---

what is the difference between sql and t-sql? : Transact sql

1 Answers  

---

What is the difference between row level and statement level trigger?

1 Answers  

---

Can two tables have same primary key?

1 Answers  

---

Does sql use python?

1 Answers  

---

Is sql sequential or random?

1 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

Types of backups ?

3 Answers   TCS,

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

What is pl sql in oracle?

1 Answers  

---