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
Why do we need oracle client?
How many types of database triggers exist?
Explain the use of indexes option in exp command.
What is a nvl function? How can it be used?
Explain the difference between replace() and translate() functions in oracle?
Explain about your project and its relation to the current job position you are applying to?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is MTTR advisor in Oracle?
what is the scenario where you take the database to NoArchivelog mode?
What do you mean by a deadlock?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to get a list of all background sessions in the database?
How to delete a column in an existing table?
Is rowid unique in oracle?
How to change system global area (sga) in oracle?