We are migrating from oracle to teradata.We are using the below query in Oracle environment:
select max(level) from ${CBG_REPOS_SCHEMA}.t_cbgdw_invlv_party_x_invlv_pa
start with OBJ_INVLV_PARTY_ID=:invlv_party_id
CONNECT BY PRIOR obj_invlv_party_id = subj_invlv_party_id
We converted it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.