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. |
|
|||
|
| |||||
| Java - 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 ? | |||||
