Whatz the main diff between Subquery and a Join
- 14 Answers
- 29131 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / affan
the main diff is
the subquery gives the result from one table only,but whose condition may depend on another table i.e the inner query.
whereas join gives the result from both the tables if condition is satisfied
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How does the on-delete-cascade statement work?
Give the advantages and disadvantages of clusters.
What is raw datatype in oracle?
Does oracle partitioning improve performance?
Explain integrity constraints?
Can we create database in oracle using command line ?
How can we find out the duplicate values in an oracle table?
what are steps for interface? where is exchange rate defined in which table?
Oracle
How to drop an existing table in oracle?
what is a Nested Loop join?
Why does Oracle not permit the use of PCTUSED with indexes?
How does Oracle guarantee data integrity of data changes?
Difference between the “verify” and “feedback” command?
Why do we use coalesce function in oracle?
