Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between join and a subquery?
- 8 Answers
- 45327 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
Can sub procedure/function be called recursively?
what are steps for interface? where is exchange rate defined in which table?
How to rename a column in an existing table?
What are the different types of record groups in oracle? Explain each of them
How to get last row id?
What is a dynamic performance view in oracle?
How to call a stored function with parameters?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to handle a single quote in oracle sql?
What is tns entry?
What is the data type of dual table?
What is a cursor in oracle?
What are the limitations oracle database 10g xe?
what is port in oracle? how is it related to database application.
How to rename an index?
