IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

What is optimistic concurrency control? : Transact sql

0 Answers  

---

What is the usage of when clause in trigger?

0 Answers  

---

What are the commands used in sql?

0 Answers  

---

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

---

Is join and inner join the same?

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

Can I join the same table twice?

0 Answers  

---

What are the data types allowed in a table?

3 Answers  

---

What is sorting in sql?

0 Answers  

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---