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 are oracle functions?
Give the constructs of a package, function or a procedure.
What is oracle latest version?
How can windows applications connect to oracle servers?
What is oracle database client?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how to make an oracle object
What are the different types of failures that occur in Oracle database?
What is Reduced List of Values?
What is the usage of control file in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to start your 10g xe server?
How to use subqueries with the exists operator in oracle?
Write a trigger example in oracle?
How to use existing values in update statements using oracle?