Whatz the main diff between Subquery and a Join
- 14 Answers
- 29110 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / pardeep chadha
Majorly subqueries run independently and result of the
subquery used in the outer query(other than corelated subquery).
And in case of join a query only give the result when the
joining condition gets satisfied.
| Is This Answer Correct ? | 32 Yes | 11 No |
Post New Answer View All Answers
Does oracle charge for java?
Explain alias?
Give the constructs of a package, function or a procedure.
How to use an explicit cursor without open statements?
What is a dynamic performance view in oracle?
What is a dead lock in oracle?
What do you understand by a database object?
Difference between open_form and call_form in oracle.
How will you identify oracle database software release?
How to Truncate Table in Oracle
What is a nvl function? How can it be used?
What is oracle latest version?
What are the attributes of the cursor?
Where are the settings stored for each instance in oracle?
What is oracle and what are its different editions?
