What are joins..how many types of joins are there?
- 29 Answers
- 76744 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
How to drop a tablespace?
What is the oracle implicit cursor?
Can you tell me how to add new column in existing views?how?How is possible?
What is a system tablespace and when it is created?
Can a formula column be obtained through a select statement ?
how do u setup a replication site?
Where do we use decode and case statements?
What is concurrency in oracle?
How many types of cluster table in Oracle?
What is rich query?
What to do if the startbd.bat failed to start the xe instance?
what is the dual table in oracle?
How to see the table columns used in an index?
How to check database size in Oracle?
How would you go about verifying the network name that the local_listener is currently using?
