Difference between join and a subquery?
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
What are the different pseudo commands? Explain in general?
How to convert csv to table in oracle?
Why do we use bulk collect in oracle?
Explain a synonym?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is the difference between alert log file and tarce file ?
How to resolve name conflicts between variables and columns?
How to create a table in a specific tablespace?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How many memory layers are in the oracle shared pool?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What do you mean by merge in oracle?
Why we use bulk collect in oracle?