Question: what is inner join and outer join in oracle?
Answer: INNER JOIN operation. Specifies a join between two tables with an explicit join clause. LEFT OUTER JOIN operation. Specifies a join between two tables with an explicit join clause, preserving unmatched rows from the first table.