Left outer join or Right outer join on Oracle

[Tejas Jain]

I have two tables: employee and department. The employee table has a foreign key dep_id pointing to the primary key, dep_id, of the department table.

Outer Left Join: SELECT d.name, e.name FROM department d, employee e WHERE d.dep_id = e.dep_id (+);

Do I get a Outer Right Join by just switching the sides on equal sign (=) like following?
SELECT d.name, e.name FROM department d, employee e WHERE e.dep_id (+) = d.dep_id;

They are both valid SQL statements. I guess the result set should be the same. Correct?

[Martin Vajsar]

Yes, the two statements are identical.

Similarly with the ANSI syntax, a left join can always be expressed as a right join (and vice versa), simply by reversing the order of the tables.