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

Can we call stored procedure in function?

964

---

Why cross join is used?

1083

---

How to add new employee details in an employee_details table with the following details

1091

---

what is msql? : Sql dba

994

---

What is type and rowtype in pl sql?

1020

---

Are pl sql variables case sensitive?

1053

---

What is cartesian join in sql?

1135

---

What is scalar data type in pl sql?

1074

---

What is the difference between jpql and sql?

1099

---

Why do we use cursors?

991

---

what are the performance and scalability characteristics of mysql? : Sql dba

999

---

Does sql view stored data?

962

---

Why stored procedure is better than query?

949

---

What is partition by in sql?

1071

---

What is a unique constraint?

1080

---