Whatz the main diff between Subquery and a Join
Answer Posted / srijina
join combines tables and retrieves data where as sub query
doesn't combines two table.join is more faster than subquery
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How to create a stored program unit?
master table and child table performances and comparisons in Oracle ?
Explain the use of ignore option in imp command.
How do I find my oracle client driver version?
What are the oracle differences between nvl and coalesce
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How to select all columns of all rows from a table in oracle?
Can you have more than one content canvas view attached with a window ?
How to name query output columns in oracle?
Give the advantages and disadvantages of clusters.
How to set up autotrace for a user account?
How to create a table index?
How to sort output in descending order in oracle?
How do I know if oracle is installed on windows?
What is set operator oracle?