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 semphore explian it?

2815

---

1. What is PO rate variance gain and loss?

2919

---

QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS

2067

---

8. Supporting AP, AR and GL?

2308

---

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

1276

---

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

4446

---

What is the difference between conversions and interfaces? : oracle accounts receivable

1230

---

What is the disk migration? what is the steps involved in oracle disk migration?

1221

---

What is Tax Categories?

2112

---

Difference between negative and positive adjustments : oracle accounts receivable

1104

---

What Are Cross Validation & Adi?

1157

---

key flexfield structure

2176

---

how to write customizations in po

1618

---

What do you mean by Oracle MEDIA RECOVERY?

1226

---

types of receipts and detail desription about recipts and tables effected by receipts?

2075

---