Whatz the main diff between Subquery and a Join
Answer Posted / anbu
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 ? | 17 Yes | 4 No |
Post New Answer View All Answers
How to change system global area (sga) in oracle?
What is the quickest way to fetch the data from a table?
master table and child table performances and comparisons in Oracle ?
What is an oracle?
How index is implemented in oracle database?
Explain the use of grant option in imp command.
How to drop an index in oracle?
What is a trigger and what are its types?
What is the Tune Query
What is parameterized cursor in oracle?
what is the use of system.effective.date variable in oracle?
What are the differences between blob and clob in oracle?
Explain about achiever in sql?
In oracle there is column command, how will you explain that?
Explain the difference between a procedure and a function? What do you understand by those terms?