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 are different types of transactions in ar? : oracle accounts receivable

1217

---

How would you determine what sessions are connected and what resources they are waiting for?

2070

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

1103

---

What Are Cross Validation & Adi?

1096

---

how to replace not in with not exist?

3657

---

3. Steps in UAT?

2364

---

which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2433

---

What is autocashrule set? : oracle accounts receivable

1292

---

what are the tools used for oracle 10g in real time.

2371

---

Explain the payment term in ar. : oracle accounts receivable

1055

---

what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1062

---

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

2011

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2014

---

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2106

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1257

---