Whatz the main diff between Subquery and a Join
- 14 Answers
- 31207 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
How to create a table index in oracle?
Explain compound trigger in oracle?
Why do we use coalesce function in oracle?
How to define an oracle sub procedure?
List out the components of logical database structure of oracle database.
How to view all columns in an existing table?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What are the numeric comparison operations?
Who developed oracle & when?
How many types of table in Oracle?
How can we find out the current date and time in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to use "out" parameter properly?
master table and child table performances and comparisons in Oracle ?
IS it possible to built the oracle database without setting the kernal parameters?
