Answer Posted / chintu

A query is nothing but if we want to evaluate one thing we
will write query. like
select * from emp; --->> query

A Query is evaluated once for each and every row from the
parent statement is called corellated Query.
like
select * from emp outer where sal= ( select avg(sal) from
emp e where dept.e=dept.outer) --> corelated query

What is the use of pl/sql table?

1062

---

What is indexing oracle sql?

1097

---

How do I run a program in pl sql?

998

---

What is pl/sql table? Why it is used?

1032

---

What is the purpose of using pl/sql?

1142

---

What is the use of function "module procedure" in pl/sql?

1192

---

Is sql between inclusive?

1121

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

953

---

What is the life of an sql statement?

1017

---

What is tuple in sql?

1070

---

What is structural independence and why is it important?

1028

---

What is sql and db2?

995

---

What is the use of non clustered index?

988

---

What is the difference between the implicit and explicit cursors?

1046

---

What is the difference between subquery and correlated query?

1060

---