what is meant by DML?

5 Answers   HCL,

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

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,

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

What is correlated sub-query?

7 Answers   Oracle,

---

Is natural join same as inner join?

0 Answers  

---

how to write utl file pkg in SQL

1 Answers   Oracle,

---

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

---

Is it important to partition hard disk?

0 Answers  

---

Does execute immediate commit?

0 Answers  

---

What is the default isolation level in sql server? : Transact sql

0 Answers  

---