Answer Posted / sravzzz

Sunbquery is a query within a query where as Nested query
is a subquery which resinde in the WHERE clause.

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'));

1686

---

what are the default admin accounts in Oracle 10g ?

963

---

How to get maxsal , minsal, ename department wise in single query

1543

---

What is the meaning of recursive hints in oracle?

1044

---

How to rename an index in oracle?

1107

---

How to update a table row with a record?

1006

---

Explain what are synonyms used for?

1032

---

What are the system predefined user roles?

1035

---

Query to retrieve record for a many to many relationship ?

2507

---

What are advantages of dateset in datastage?

2257

---

What privilege is needed for a user to create views in oracle?

1035

---

How can we find out the current date and time in oracle?

1086

---

What is the difference between view and materialized view in Oracle?

1139

---

What is oracle data type?

955

---

Why do we use bulk collect in oracle?

1056

---