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 is the difference between substr and instr function in oracle?

1034

---

Explain the difference between a procedure and a function?

1086

---

Explain oracle’s server parameter file.

947

---

Explain what are the advantages of views?

1013

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2995

---

What is oracle update statement with inner join ?

993

---

Is oracle an operator?

883

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2151

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1871

---

What is a snapshot log?

949

---

Is oracle a programming language?

936

---

How to display row numbers with the records?

1024

---

What do you understand by a database object? Can you list a few of them?

970

---

Can group functions be used in the order by clause in oracle?

939

---

How will you write a query to get a 5th rank student from a table student_report?

1813

---