Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

What is a sql*loader control file?

0 Answers  

---

How can you fetch common records from two tables?

0 Answers  

---

How to run sql functions in pl/sql?

0 Answers  

---

what is meant by databases

4 Answers  

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

what are Dynamic SQL statements?

9 Answers  

---

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,

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What operators deal with null?

0 Answers  

---

what are properties of a transaction? : Sql dba

0 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---