Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97090 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / khaleek
There are three types of joins Equi Join and Non-Equi Join
and Cross Product.
Further Equi join can be divided into following categories...
1) Outer Join
2) Inner Join
3) Self Join
Again Outer join can be divided into following categories..
1) Right Outer Join
2) Left Outer Join
3) Full Outer Join
You can see the detail at..
http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define oracle database
How to store pictures on to the database?
How to bring a tablespace offline?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to start a specific oracle instance?
What is a partition in oracle?
Why do we need integrity constraints in a database?
How to declare a local variable?
What is using clause and give example?
What do database buffers contain?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How oracle handles dead locks?
What is the sql query to concatenate column values from multiple rows in oracle?
In which language oracle has been developed?
