What are joins..how many types of joins are there?
- 29 Answers
- 76522 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
Explain what are the characteristics of data files?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is Data Dictionary Cache in Oracle?
How to create a table interactively?
What is oracle database 10g express edition?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What is bulk collect in oracle?
How to write a left outer join with the where clause in oracle?
How to bring a tablespace offline?
How to convert csv to table in oracle?
What is connection pooling in oracle?
How does one get the view definition of fixed views/tables?
Explain database link?
How different is ms access and oracle?
Explain enable novalidate constraint.
