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;

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

2402

---

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

2191

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1777

---

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

1166

---

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

1157

---

How do you create a credit note against an invoice? : oracle accounts receivable

1088

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1348

---

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2402

---

How to clone the database using RMAN back

2244

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2957

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2472

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2217

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1197

---

What is chargeback invoice? How do we create it? : oracle accounts receivable

1333

---

what are basic modules required to implement oracle application in any oraganisation?

2211

---