Answer / Chetan Anand

The types of triggers are: 1) DDL Triggers (Data Definition Language): These are triggered by events like CREATE, ALTER, or DROP statements. 2) DML Triggers (Data Manipulation Language): These are triggered by events like INSERT, UPDATE, or DELETE statements.

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

What is the difference between microsoft access and sql?

1 Answers  

---

What does plv msg allows you to do?

1 Answers  

---

What is the difference between the Primary and Foreign key?

7 Answers   Cap Gemini,

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

Explain 3 basic parts of a trigger.

1 Answers  

---

What mean sql?

1 Answers  

---

Does pl sql work in mysql?

1 Answers  

---

What is sql clause?

1 Answers  

---

Is it possible to sort a column using a column alias?

1 Answers  

---

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 Answers  

---

Define implicit and explicit cursors.

1 Answers  

---