1.

Please explain oracle left join with an example?

Answer»

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;


Discussion

No Comment Found

Related InterviewSolutions