Whatz the main diff between Subquery and a Join
Answer Posted / adil khan
main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is a connect identifier?
Does oracle partitioning improve performance?
what is normalisation?what are its uses?
How does Oracle guarantee data integrity of data changes?
How would you go about verifying the network name that the local_listener is currently using?
IS it possible to built the oracle database without setting the kernal parameters?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is the difference between postgresql and oracle?
State and explain the different types of data models?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Differentiate between post-database commit and post-form commit?
How to estimate disk space needed for an export job?
What is a table index?
Is oracle an operator?
Is java required for oracle client?