Hi,
can you help me to find the equivalent statement?
I have

select p.part_id, s.supplier_name
from part p, supplier s
where p.supplier_id = s.supplier_id (+);

the equivalent statement is

select p.part_id, s.supplier_name
from part p left outer join supplier s
on p.supplier_id = s.supplier_id;

or

select p.part_id,s.supplier_name
from supplier s right outer join part p
on s.supplier_id = p.supplier_id ;