Answer Posted / ramesh reddy veerabhadra

Basically Sub Query is Query within Query. There are different type of SubQuery.

1. Scalar Sub Query

Query that is totally independent from the main query.

select empno, (select count(*) from emp) total_emp
from emp


here the subquery is totally independent of the main query.

2. Corelated Sub Query

The sub query reffers to the main query.

select empno, (select deptname from dept d where e.deptno = d.deptno) deptname
from emp e


3. Inline view

A sub query that is used as a table or view in a SQL

select *
from (select empno, deptname
from emp e, dept d
where e.deptno = d.deptno)
where sal > 100

Can we modify approve purchase order?if yes what is navigation?

1960

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4403

---

can u give guidance abt packages of plsql

2116

---

as a technical developer in oracle applications which type errors feced in your experience sofar

2155

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2028

---

Why more redos are generated when the oracle database is in begin backup mode?

1087

---

Differentiate between transaction type and transaction source? : oracle accounts receivable

1076

---

What Are Cross Validation & Adi?

1108

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1232

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

2371

---

What is the importance of batch source set up in ar? : oracle accounts receivable

1209

---

What is the sql query to find the employee who has Nth maximum salary?

5238

---

What is supporting issues GL AP and AR?

2482

---

what is semphore explian it?

2765

---

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

1236

---