Am trying to convert Oracle SQl into Teradata, but i could not found out the equivalent function in oracle.
Please suggest me how to connect below oracle SQL into teradata.
I believe that in Oracel START WITH... CONNECT BY clause is used to select the hierarichal data. Teradata doesn't support this clause but you can achieve similar functionality by writing Recursive Queris.
See the recursive query section in Teradata SQL manual, you should be able to find related examples...