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.
BY Best Interview Question ON 19 Feb 2019
Example
syntax:-
SELECT columns
FROM table1
LEFT JOIN table2
ON table1.column = table2.column;