Hi All ,
I was using below query to find parent child table
SELECT M.CONSTRAINT_NAME,
M.TABLE_NAME AS MASTABLENAME,
D.TABLE_NAME AS DETTABLENAME
FROM aLL_CONSTRAINTS M, ALL_CONSTRAINTS D
WHERE M.OWNER = '*****' AND D.OWNER = '****' AND
M.TABLE_NAME = '*****' AND
M.CONSTRAINT_NAME = D.R_CONSTRAINT_NAME AND
D.CONSTRAINT_TYPE = 'R' AND M.CONSTRAINT_TYPE = 'P';
but this is some how not fulfilling the requirement because
the child table is in output also has child tables and so on..
can any one let me know how to achieve this..
thanks in advance