Interested to Buy Any Domain ? << Click Here >> for more details...
What are joins..how many types of joins are there?
- 29 Answers
- 97175 Views
- Amdocs, CSC, TCS, I also Faced
- E-Mail Answers
Answer Posted / deepika s verma
In Oracle we can catogrise joins in following ways -
(1) Equi Join (Query having joining condition)
- Natural Join
- Join Using
- Join ON
(2) Non Equi Join or Cartesian Join ( without using joining
condition)
(3)Outer Join
- left outer join
- right outer join
- full outer join
(4) self Join or Theta Join
(5) Cross Join
(6) Inner Join
| Is This Answer Correct ? | 35 Yes | 16 No |
Post New Answer View All Answers
What is integrity and what is constraint??Explain with example
What is meant by recursive hints in oracle?
Explain the use of show option in imp command.
What is the string concatenation operator in oracle?
How to experiment a data lock in oracle?
What are the differences between date and timestamp in oracle?
Name the various constraints used in oracle?
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?
Explain joins in oracle?
What are the oracle built-in data types?
How to invoke the data pump import utility?
What are a collation and state the different types of collation sensitivity?
What is a select query statement in oracle?
How to insert a new row into a table in oracle?
What is query image?
