Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33526 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 export several tables together?
What is format trigger?
Which are the five query types available in oracle?
Explain integrity constraint?
How to create a single index for multiple columns?
Point out the difference between user tables and data dictionary?
How to resolve name conflicts between variables and columns?
How to set up autotrace for a user account?
Explain the use of constraints option in exp command.
What is a server parameter file in oracle?
query optmization techniques and quwry analyser+projects+ppts
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How can I combine multiple rows into a comma-delimited list in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What privilege is needed for a user to query tables in another schema?
