Interested to Buy Any Domain ? << Click Here >> for more details...
Whatz the main diff between Subquery and a Join
- 14 Answers
- 33917 Views
- Oracle, Zeta Interactive, I also Faced
- E-Mail Answers
Answer Posted / affan
the main diff is
the subquery gives the result from one table only,but whose condition may depend on another table i.e the inner query.
whereas join gives the result from both the tables if condition is satisfied
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Is java required for oracle client?
What is an oracle transaction?
What privilege is needed for a user to connect to oracle server?
What are the differences between lov and list item?
What is different types of joins?
What are named parameters?
Explain the dml?
Why do we use coalesce function in oracle?
what is dynamic SGA and static SGA
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.
Point out the difference between user tables and data dictionary?
Why is oracle used?
Explain what are the characteristics of data files?
Difference between hot backup vs. Cold backup?
