Oracle Outer Join Simplified

If your using oracle, you do not need to use the OUTER JOIN keyword when you are joining tables as oracle has its own syntax. You can use the below comman to outer join tables in oracle;

 

select * from passenger a, reservation b where a.res_id(+) = b.id;