What are joins..how many types of joins are there?
- 29 Answers
- 76854 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / mouli
Joins allows you to read or report the data from more than 1 table. There are four types of joins are there..
1) equi join or inner join or natural join
2) non equi join
3) outer join
a)left outer join
b)right outer join
c)full outer join
4) self joins
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to use "in" parameter properly?
What is a user role in oracle?
What is data block in Oracle?
How will you identify oracle database software release?
How to install oracle odbc drivers?
How to run queries on external tables?
What is a snapshot in oracle database?
What is archive log in Oracle?
What is the parameter mode that can be passed to a procedure?
what are bitmap indexes? How does they work?
Why is oracle database so popular?
How to start your 10g xe server from command line?
How do I uninstall oracle client from windows?
How to use like conditions in oracle?
6. Display the client name and order date for all orders using the traditional method.
