Answer Posted / asnani_satish@yahoo.com

Minor correction in above answer
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,avg(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" containing dept wise average sal. The query
is behaving as a temporary table.

What is indexing oracle sql?

1142

---

How do I upgrade sql?

1048

---

how to delete an existing column in a table? : Sql dba

1056

---

what are aggregate and scalar functions? : Sql dba

1104

---

Does oracle roll back the transaction on an error?

1065

---

Explain the significance of the & and && operators in pl sql.

1046

---

Why we use triggers in mysql?

1035

---

Explain the methods used to protect source code of pl/sql.

1068

---

What is difference between sql and oracle?

1188

---

Can there be more than one function with a similar name in a pl/sql block?

1040

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2142

---

Which is faster count (*) or count 1?

1086

---

What are sql ddl commands?

1136

---

What is the difference between unique and primary key constraints?

1118

---

How do I count records in sql?

1051

---