How to best split csv strings in oracle 9i?

0 Answers  

---

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,

---

How to get a list of all user accounts in the database?

0 Answers  

---

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,

---

What does sharding mean?

0 Answers  

---

According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 Answers  

---

How many types of segments in Oracle?

0 Answers   MCN Solutions,

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---

State and explain the different types of data models?

0 Answers  

---

State any two functions of oracle?

0 Answers   Aricent,

---

What do you mean by merge in oracle and how can we merge two tables?

0 Answers  

---