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
What happens if you set the sga too low in oracle?
What the is the diff between local index and global index. give some example.
How to convert characters to numbers in oracle?
What is varray?
What is the difference between Delete, Truncate and Drop in Oracle?
What happens to the current transaction if a ddl statement is executed?
How do I find my oracle client driver version?
what are bitmap indexes? How does they work?
How do we get field details of a table?
What are transaction isolation levels supported by oracle?
What to do if the startbd.bat failed to start the xe instance?
What is oracle datasource?
What is meant by joins? List out the types of joins.
How to upsert (update or insert into a table)?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....