various types of joins

Answer Posted / s. senthil kumar

There are Two Types of joins:

I. Inner Join
II. Outer Join


I: Inner join:a) Equi join, b) Non Equi join c) self join
II: Outer join: a) Left outer join, b) right outer join,
c) Full outer join

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to empty your oracle recycle bin?

572


How to create a temporary table in oracle?

693


What do you mean by a database transaction & what all tcl statements are available in oracle?

549


How will you differentiate between varchar & varchar2?

587


How can windows applications connect to oracle servers?

520






how do u setup a replication site?

1496


What is oracle database client?

553


What is a parameter file in oracle?

560


What are the parameters that we can pass through a stored procedure?

552


Which is better Oracle or MS SQL? Why?

5433


How to best split csv strings in oracle 9i?

585


Is there a function to split a string in plsql?

568


Is oracle an operator?

533


What is an oracle user account?

578


What is the use of file param in imp command?

642