Re: parent/child rel.

You could use something like this one:

SELECT DISTINCT A.TABLE_NAME KIND,
       B.TABLE_NAME PAPA
FROM USER_CONSTRAINTS A,
       USER_CONSTRAINTS B

WHERE  A.R_CONSTRAINT_NAME = B.CONSTRAINT_NAME(+)
AND    B.TABLE_NAME = 'T_TRYL'
AND    A.TABLE_NAME != B.TABLE_NAME

Regards,

Jörg Received on Wed Mar 22 2006 - 06:14:56 CST