write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,

---

How do we get field detail of a table?

0 Answers  

---

How to retrieve 5th highest sal from emp table?

8 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

Explain the use of owner option in exp command.

0 Answers  

---

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

---

How to get a list of all background sessions in the database?

0 Answers  

---

How to create a stored program unit?

0 Answers  

---

What do you mean by group by clause?

0 Answers  

---

What is a OUTER JOIN?

1 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

What is the use of Redo Log Information ?

2 Answers  

---