What are joins..how many types of joins are there?
- 29 Answers
- 76664 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 an index associated with a constraint?
How to open a cursor variable?
What is the difference between sharding and replication?
What is connection pooling in oracle?
How to export your own schema?
How to load a large xml file?
How to open and close an explicit cursor in oracle?
What is the quickest way to fetch the data from a table?
Write a trigger example in oracle?
How to define a record variable to store a table row?
What happens if the imported table already exists?
Explain the use of indexes option in exp command.
What is oracle latest version?
How to view all columns in an existing table?
How to use "startup" command to start default instance?
