Difference between join and a subquery?
Answer Posted / kiran
subquery can be used for simple logical queries , to get
required output/condition
but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins
Is This Answer Correct ? | 39 Yes | 5 No |
Post New Answer View All Answers
What is a tns file?
How many types of cluster table in Oracle?
What is Data Dictionary Cache in Oracle?
What is the string concatenation operator in oracle?
How to use "while" statements in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to store only time; not date and time?
How to define default values for formal parameters?
What is the difference between translate and replace in oracle?
How to write a left outer join with the where clause in oracle?
What is meant by a deadlock situation?
What are the differences between primary key and unique key?
What is the meaning of recursive hints in oracle?
How to display row numbers with the records?
How to login to the server without an instance?