Answer Posted / asnani_satish@yahoo.com

Difference between sub-query, correlated query and query as
table
1. Sub-query : the inner query is executed in entirety
before the outer query is executed
eg select * from emp where deptno in (select deptno from dept);

2. Correlated Query: For each record fetched in outer query
corresponding matching records are fetched in sub-query
because of join condition within inner sub-query. Answers
1,2,3 are correct

3. Query as Table: A query can behave as a table

select a.empno,a.sal,a.sal/b.avgsal*100 as percent_avg_sal
from emp a,(select deptno,sum(sal) avgsal from emp group by
deptno) b
where a.deptno=b.deptno;

Here the entire "(select deptno,avg(sal).....)" behaves as
table named "b". The query is behaving as a temporary table.

What is sequence in sql?

1078

---

In pl/sql, what is bulk binding, and when/how would it help performance?

1036

---

What is a temp table?

1074

---

tell us something about heap tables. : Sql dba

1146

---

What are stored procedures used for?

1053

---

What is inner join in sql?

1139

---

Is it possible to sort a column using a column alias?

1105

---

What is the difference between join and natural join?

984

---

What are reports usually used for?

1085

---

What is set transaction?

1090

---

What is %type in sql?

1020

---

How does sql developer connect to oracle database?

1051

---

Can we debug stored procedure?

1069

---

How many functions are there in sql?

1096

---

How to call a javascript function from pl sql?

1187

---