Whatz the main diff between Subquery and a Join
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
What is the difference between view and materialized view in Oracle?
What are the different pseudo commands? Explain in general?
What is oracle latest version?
What is a user role in oracle?
What is the use of file param in imp command?
Is insert autocommit in oracle?
Why do you use stored procedures and state some of its disadvantages?
How to delete all rows a table in oracle?
How to define an explicit cursor in oracle?
What is meant by an index?
What is java oracle used for?
What exactly do quotation marks around the table name do?
What privilege is needed for a user to connect to oracle server?
What is flashback in Oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?