Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45074 Views
- Base Automation, NMDC, I also Faced
- E-Mail Answers
Answer Posted / bhuvana
Joins-
1.Want to combine and fetch data from more than 2 tables.
2.Joins are faster, efficient, easy to understand and better performance.
Subquery-
Want to combine and fetch data from a pair of table.
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
How to view the tablespaces in the current database?
How many file formats are supported to export data?
How does Oracle guarantee data integrity of data changes?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is max rowid in oracle?
What are the differences between number and binary_float in oracle?
What is different types of joins?
types of indexes and the rationale behind choosing a particular index for a situation.
Can a formula column referred to columns in higher group ?
How to resolve name conflicts between variables and columns?
What is the difference between a hot backup and a cold backup in oracle?
What happens to the indexes if a table is recovered?
In which language oracle has been developed?
What is a tns service name?
What is oracle in java?
