What are joins..how many types of joins are there?
- 29 Answers
- 76441 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 synchronize 2 schema's objects?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Why do you use stored procedures and state some of its disadvantages?
How to assign values to variables?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to use "startup" command to start default instance?
How to count groups returned with the group by clause in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Is it possible to insert comments into sql statements return in the data model editor ?
How different is ms access and oracle?
How many categories of data types in oracle?
How many types of tables supported by oracle?
What are the extensions used by oracle reports?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is the difference between sharding and partitioning?
