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