Search Interview Questions | More than 3000 questions in repository. There are more than 900 unanswered questions. Click here and help us by providing the answer. Have a video suggestion. Click Correct / Improve and please let us know. |
|
| ||||
Interview Questions and Answers | ||||
| ||||
Ans. Oracle having following types of joins these are also called 8i joins. There are: 1. Equi (or) Inner join 2. Non Equi join 3.Self join 4.Outer join Oracle also support the 9i (or) ANSI standard joins.There are: 1.Inner join 2.Left outer join 3.Right outer join 4.Full outer join 5.Natural join | ||||
Help us improve. Please let us know the company, where you were asked this question : | ||||
Like Discuss Correct / Improve  sql joins  sql Asked in 2 Companies | ||||
Related Questions | ||||
If Table A has 100 records and Table B has 50 records , how many records will the left join of Table A with Table B generate ? | ||||
If Table A has 100 records and Table B has 50 records , how many records will the right join of Table A with Table B generate ? | ||||
If Table A has 0 records and Table B has 50 records , how many records will the equi join of Table generate ? | ||||