WITH TROOT (ROW_ID,PARENT_MODULE_ID,MENU_NAME)
AS (
?????????SELECT ROW_ID,PARENT_MODULE_ID,MENU_NAME FROM????????? ad_program?
???????? WHERE row_id=50
???????? UNION?ALL
?????????SELECT A.ROW_ID,A.PARENT_MODULE_ID,A.MENU_NAME
???????? FROM ad_program A,TROOT B?
???????? WHERE? A.PARENT_MODULE_ID=B.ROW_ID
)
SELECT * FROM TROOT