Answer Posted / lakshmi

Correlated subquery runs once for each row selected by the
outer query. It contains a reference to a value from the
row selected by the outer query.
Nested subquery runs only once for the entire nesting
(outer) query. It does not contain any reference to the
outer query row.
For example,
Correlated Subquery:
select e1.empname, e1.basicsal, e1.deptno from emp e1 where
e1.basicsal = (select max(basicsal) from emp e2 where
e2.deptno = e1.deptno)
Nested Subquery:
select empname, basicsal, deptno from emp where (deptno,
basicsal) in (select deptno, max(basicsal) from emp group
by deptno)

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

---

What is Undo Management Advisor in Oracle?

1099

---

What is set verify off in oracle?

1106

---

How to download oracle database 10g xe?

1018

---

How to start an oracle instance?

1019

---

How to work with data objects interactively?

984

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

---

Explain the use of owner option in exp command.

1046

---

What does sharding mean?

1002

---

How to use like conditions in oracle?

1056

---

What is the data type of dual table?

995

---

What are the restrictions in a oracle read only transaction?

1036

---

How to assign values to data fields in record variables?

1035

---

How do I connect to oracle database?

1119

---

What is user managed backup in Oracle?

1146

---