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 Available!