Whatz the main diff between Subquery and a Join
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 to add a new column to an existing table with a default value?
What is the difference between $oracle_base and $oracle_home?
How to change user password in oracle?
What is the difference between translate and replace in oracle?
Explain the use of tables option in exp command.
How many types of tables are there in oracle?
What is a static data dictionary in oracle?
How to rename a column in an existing table?
How would you go about verifying the network name that the local_listener is currently using?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Oracle
What is the difference between substr and instr?
What is merge in oracle?
Explain the use of indexes option in imp command.
How to download oracle database 10g xe?