what is different between inline query,subquery& corelated
query?
- 8 Answers
- 104825 Views
- Quest, I also Faced
- E-Mail Answers
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;
| Is This Answer Correct ? | 19 Yes | 6 No |
Post New Answer View All Answers
What view would you use to determine free space in a tablespace?
How do you create a credit note against an invoice? : oracle accounts receivable
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
How would you determine what sessions are connected and what resources they are waiting for?
HOW TO SPOT AHIERARCHY?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the use of lockboxes? : oracle accounts receivable
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
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.
Differentiate between transaction type and transaction source? : oracle accounts receivable
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
Explain the use of table functions.
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.
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
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.
