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

What is the difference between recovery and restoring of the oracle database?

1211

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2106

---

What is the mandatory setup in cyclecount ?

2744

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1332

---

How to clone the database using RMAN back

2221

---

What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3929

---

HOW TO SPOT AHIERARCHY?

2285

---

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2391

---

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

2131

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1139

---

Are These Dff's Flexible?

1164

---

What do you mean by Oracle MEDIA RECOVERY?

1217

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2094

---

What is auto invoicing? : oracle accounts receivable

1150

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2255

---