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;

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

1083

---

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

2491

---

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.

2179

---

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2190

---

Give two methods you could use to determine what DDL changes have been made.

6761

---

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2164

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1252

---

Explain about party and customer in ar : oracle accounts receivable

1200

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2301

---

What is an Oracle database Full Backup?

1125

---

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

1151

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2106

---

what is semphore explian it?

2804

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1127

---

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

2312

---