Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97142 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / prabhat shukla
Basically there are three types of join
1.Inner join
2.Outer join
3.self join
and there are two types of join based on condition.
1.equi-join(if we use equal operator while joining tables)
2.Non-equi-join( if we use other than equal operator while
joining tables.(this on is rarely used.)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain oracle data types with examples?
How can we view last record added to a table?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Is oracle a programming language?
Explain integrity constraint?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Explain what are the different type of segments?
What is primefaces used for?
Can objects of the same schema reside in different tablespace?
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 I find the database name in oracle?
Can group functions be mixed with non-group selection fields?
What is the usage of save points in oracle database?
What are the parameters that we can pass through a stored procedure?
