Oracle JOIN with Example

To select data from two or more table Oracle join is used.

There are the different types of the JOINs in Oracle:

Inner join

left join

Right join

Full join

Oracle JOIN Example

Assume that we have two table

students_data table

RollNo Name Address ContactNo
1 Divya Mumbai 9437911966
2 Hritika Pune 9887454545
3 Amit Delhi 7766888888

students_mark table

RollNo Mark Grade
1 95 O
2 85 A
3 65 B


SELECT students_data.RollNo, students_data.Name, students_data.Address, students_mark.Marks, students_mark.Grade
FROM students_data
INNER JOIN students_mark ON students_data.RollNo = students_mark.RollNo;
RollNo Name Address Mark Grade
1 Divya Mumai 95 O
2 Hritika Pune 85 A
3 Amit Delhi 65 B

Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)