Loading…

Please explain oracle left join with an example?

Left join returns all the records from the left-hand side of the table which is specified in the ON condition, only those records from the right table where the join condition is met.

Example

                                        

syntax:-

SELECT columns

FROM table1

LEFT JOIN table2

ON table1.column = table2.column;

Suggest An Answer

No suggestions avaliable!

Latest post from Oracle Interview Questions

Ask Question