Whatz the main diff between Subquery and a Join
- 14 Answers
- 29129 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
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
What language does oracle use?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to loop through a cursor variable?
What is meant by a deadlock situation?
What is SQL access advisor in Oracle?
What happens if you set the sga too low in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Explain an integrity constrains?
How to define an oracle cursor variable?
What is an oracle recycle bin?
How to fetch the row which has the max value for a column?
How do I learn what codesets are available in oracle?
Can multiple cursors being opened at the same time?
How to use attributes of the implicit cursor in oracle?
How to speed up webrick?
