what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

What is the cause of mutating table error and how can we solve it?

0 Answers  

---

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

---

What are expressions?

0 Answers  

---

What is the life of an sql statement?

0 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,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

Is sql better than excel?

0 Answers  

---

What does pl sql stand for?

0 Answers  

---

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

---

how to check server status with 'mysqladmin'? : Sql dba

0 Answers  

---

Explain the savepoint statement.

0 Answers  

---