Answer Posted / vrushali

Co-related sub query is one in which inner query is
evaluated only once and from that result outer query is
evaluated.

Nested query is one in which Inner query is evaluated for
multiple times for gatting one row of that outer query.

ex. Query used with IN() clause is Co-related query.
Query used with = operator is Nested query

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 is ceil and floor in oracle?

1067

---

What are the uses of a database trigger?

989

---

What is data type in oracle?

1111

---

How to define a sub function?

1123

---

How to see free space of each tablespace?

1032

---

How to use "startup" command to start default instance?

1022

---

Does oracle charge for java?

1053

---

How to export your own schema?

1007

---

What is merge statement used for?

1019

---

Describe the types of sub query?

991

---

How to start a new transaction in oracle?

1079

---

What is the difference between a user and a schema in oracle?

1029

---

State some uses of redo log files?

995

---

Can we write dml statement in function in oracle?

1077

---