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 : | ||||
 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 ? | ||||
