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,

---

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 Answers   Wipro,

---

What are the type of Synonyms?

1 Answers  

---

How to rename an existing table?

0 Answers  

---

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

What is the maximum number of triggers that can be applied to a single table?

0 Answers  

---

List the parts of a database trigger.

0 Answers  

---

Explain the difference between sql and oracle?

0 Answers  

---

What happens if variable names collide with table/column names?

0 Answers  

---

How to select all columns of all rows from a table in oracle?

0 Answers  

---

How to join two tables in a single query using oracle?

0 Answers  

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---