What are joins..how many types of joins are there?
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 get execution statistics reports on query statements?
What are the differences between char and varchar2 in oracle?
How to increment dates by 1 in oracle?
Explain an integrity constrains?
what is the use of system.effective.date variable in oracle?
What are the different editions of oracle?
what is the difference between functional dependecy and multilevel dependency?
How to create a stored function in oracle?
How to bring a tablespace offline?
What happens to the data files if a tablespace is dropped?
What is recycle bin in Oracle?
Explain the difference between sap and oracle?
What is save point in oracle database?
What do database buffers contain?
Point out the difference between user tables and data dictionary?