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  

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

Is pl sql a programming language?

0 Answers  

---

How many sql commands are there?

0 Answers  

---

---

what are different types of keys in sql?

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---

Is sql developer case sensitive?

0 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

What is the difference between truncate and drop statements?

0 Answers  

---

What is sql architecture?

0 Answers  

---

what is constraining table?

2 Answers  

---