src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

Explain coalesce function?

0 Answers  

---

What is use of oracle?

2 Answers   Satyam,

---

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

---

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

2 Answers   Wipro,

---

How can you merge two tables in oracle?

0 Answers  

---

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

---

Point out the difference between user tables and data dictionary?

0 Answers  

---

Please explan Why static query is more faster than dynamic query ?

2 Answers  

---

Why do you create or replace procedures rather that drop and recreate.

0 Answers  

---

Can you create a synonym without having a table?

0 Answers  

---

What is a system tablespace?

0 Answers  

---