Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33544 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / suryakiran
The main usage of subqueries is to retrieve a single record
from that same table or another table.
And also we can use subqueries to retrieve multiple
records,for this we have to use multiple sub queies,instead
of this its better to use joins based on a condition.
We can perform all operations for joins by using subqueries
but it is very complicated.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a dynamic performance view in oracle?
Explain enable novalidate constraint.
How to insert multiple rows with one insert statement in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What happens if variable names collide with table/column names?
What do you know about normalization? Explain in detail?
Explain joins in oracle?
Is it possible to split the print reviewer into more than one region ?
List out the types of joins.
How a tablespace is related to data files?
What is recovery manager in Oracle?
What is a oracle database?
What are the differences between number and binary_float in oracle?
What is the difference between postgresql and oracle?
What is save point in oracle database?
