Please convert following query oracle to teradata
The (+) indicates the inner table which is filled with NULLs. This should be the same in ANSI syntax:
select address.address_id,address.state,dim_tab.src_system,di m_tab.dim_last_mdfd_dt
from address LEFT JOIN dim_tab
ON dim_tab.src_system='rama' and
Be careful, more complex queries might be hard to translate. because there are different rules for Oracle and ANSI syntax.
Thanks for your responce but i have one doubt.
dim_tab.src_system(+)='rama' here its right join why you took as a left join, i didnt get it can you please aloborate.
LEFT and RIGHT in ANSI syntax refer to the position of the table name in the JOIN.
"a left b" is the same as "b right a", in both cases a is the outer table and b is the inner table (joined or padded with NULLs).
And this is (+) in Oracle syntax.
No Teradata doesn't have packages like Oracle does...
Teradata UDFs have packages concept but that is also different from Oracle system...