Whatz the main diff between Subquery and a Join
- 14 Answers
- 29193 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 are the differences between blob and clob in oracle?
Explain the use of compress option in exp command.
How to update a table row with a record?
What is the difference between online and offline backups?
What is an oracle and why it is used?
Explain the use of inctype option in exp command.
What is the usage of control file in oracle?
Explain database link?
Explain oracle data types with examples?
How to retrieve values from data fields in record variables?
How to sort output in descending order in oracle?
What is an oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is a subquery?
What is the database name in oracle?
