Whatz the main diff between Subquery and a Join
Answer Posted / anbu
their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
How to convert a date to char in oracle? Give one example.
What is the difference between 10g OEM and 11g OEM?
Explain an index?
What is MTTR advisor in Oracle?
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.
how do u setup a replication site?
How to concatenate two text values in oracle?
How to define an oracle cursor variable?
What would you do with an in-doubt distributed transaction?
What are the ways tablespaces can be managed and how do they differ?
What is not equal to in oracle?
What is data file?
Is oracle a relational database?
Difference between open_form and call_form in oracle.
What do you mean by a deadlock?