Whatz the main diff between Subquery and a Join
Answer Posted / rajesh
their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....
| Is This Answer Correct ? | 78 Yes | 27 No |
Post New Answer View All Answers
What do you mean by group by clause?
How to connect to a remote server?
Why is oracle so popular?
How to speed up webrick?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to pass a parameter to a cursor in oracle?
How to create a stored function in oracle?
How to unlock the sample user account in oracle?
What are the set operators union, union all, minus & intersect meant to do?
What is the data pump export utility?
What is instant client oracle?
What is index-organized table in Oracle?
Can we protect our pl/sql source code?
What is a database schema in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar