Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97211 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
What are the various types of snapshots ?
How to estimate disk space needed for an export job?
What is transaction control statement and how many types of transaction control statement in Oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Are truncate and delete commands same? If so why?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Where is the export dump file located?
How to create an initialization parameter file?
How to pass parameters to procedures?
Does oracle database need java?
11. Display the client number and name and the client number and name of the person who referred that client.
How to rollback the current transaction in oracle?
What happens if the imported table already exists?
What do database buffers contain?
Can we save images in a database and if yes, how?
