Oracle Connect by Equivalent function in Teradata

Database

Oracle Connect by Equivalent function in Teradata

Hi ,

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.

SELECT * FROM EMRADMIN.MT_MOORES_ALL_OPS 

START WITH PARENT='Moores Stores'

    CONNECT BY PARENT = PRIOR CHILD 

1 REPLY
Enthusiast

Re: Oracle Connect by Equivalent function in 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...