What are joins..how many types of joins are there?
- 29 Answers
- 76769 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / pravin
Joins are used to fetch data or information from one or
more tables and there are five types of join.
1. Inner Join
2. Outer Join
3. Self Join
4. Cross Join
5. Exception Join
| Is This Answer Correct ? | 27 Yes | 40 No |
Post New Answer View All Answers
Explain an integrity constrains?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Is primary key indexed by default in oracle?
Is oracle an operator?
Explain about functional dependency and its relation with table design?
Why does for update in oracle 8 cause an ora-01002 error?
Query to retrieve record for a many to many relationship ?
What are the various constraints used in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
Explain about the analyze command in oracle?
Does facebook use oracle?
What are the different types of record groups in oracle? Explain each of them
Can we insert data in view oracle?
How to use windows user to connect to the server?
Can we convert a date to char in oracle and if so, what would be the syntax?
