Hi.

For a left outer join in Oracle, the (+) goes on the right hand side of the "=" to indicate that this item might not be present. Assuming that "etd" and "tc" are present and the other rows may not be you should writ either of these statements in Oracle:

Select x, y, z
FROM tmp_epg_txs_ids etd,
txs_containers tc,
aspect_ratios ar,
formats f,
ancsvc st,
epg_templates et
WHERE etd.id = tc.id
AND tc.aspect_ratio_id = ar.id (+)
AND tc.format_id = f.id (+)
AND tc.ansv_method_st_code = st.ancsvc_cod (+)
AND tc.epg_template_id = et.id (+);

Select x, y, z
FROM tmp_epg_txs_ids etd
JOIN txs_containers tc ON etd.id = tc.id
LEFT OUTER JOIN aspect_ratios ar ON tc.aspect_ratio_id = ar.i
LEFT OUTER JOIN formats f ON tc.format_id = f.id
LEFT OUTER JOIN ancsvc st ON tc.ansv_method_st_code = st.ancsvc_cod
LEFT OUTER JOIN epg_templates et ON tc.epg_template_id = et.id;

Cheers

Tim...