Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 32891 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / pardeep chadha
Majorly subqueries run independently and result of the
subquery used in the outer query(other than corelated subquery).
And in case of join a query only give the result when the
joining condition gets satisfied.
| Is This Answer Correct ? | 32 Yes | 11 No |
Post New Answer View All Answers
How to drop a tablespace?
What are the differences between blob and clob in oracle?
What are the different editions of oracle?
Briefly explain what is literal? Give an example where it can be used?
What are the differences between number and binary_float in oracle?
What is max rowid in oracle?
What are the major difference between truncate and delete?
Can the query output be sorted by multiple columns in oracle?
What is columnar storage what is the advantage?
How to retrieve data from an cursor to a record?
What is the use of aggregate functions in oracle?
Can a formula column referred to columns in higher group ?
Can select statements be used on views in oracle?
how to clone 9i Database on to 10g Database.
What is an oracle user account?
