what is different between inline query,subquery& corelated
query?
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
Is This Answer Correct ? | 42 Yes | 12 No |
Post New Answer View All Answers
What is Tax Categories?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
can we use lexical perameter in oracle plsql if yes how
what is the link between suppliers and banks in ap module in oracle apps? And also query?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
what are basic modules required to implement oracle application in any oraganisation?
Is there any link between pr form(purchse requisition)and po form(purchase order)
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
What do you mean by Oracle MEDIA RECOVERY?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
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?