Answer Posted / ramesh reddy veerabhadra

Subquery is the query in the main select query which runs separately and feeds its output to main query for execution. It runs only once.

SELECT ename, deptno
FROM emp
WHERE deptno = (SELECT deptno
FROM emp
WHERE ename = 'KING');


Corelated sub query uses the values from the main query and runs everytime the main query executes i.e. its simultaneous process.

SELECT ename, deptno, sal
FROM emp x
WHERE sal > (SELECT AVG(sal)
FROM emp
WHERE emp.deptno = x.deptno)
ORDER BY deptno;

can u give guidance abt packages of plsql

2234

---

Explain prerequisites and post activities of oracle database installation

2179

---

what is difference between inner join & nested query or subqueries

3107

---

can we use lexical perameter in oracle plsql if yes how

2371

---

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2301

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2036

---

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

2564

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2202

---

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1152

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1325

---

Are These Dff's Flexible?

1207

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1406

---

What is supporting issues GL AP and AR?

2612

---

A scenario for amount correction & how to use amount correction functionality in AP invoices

2188

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2559

---