recursive select in user_constraints
pvojko2Dec 10 2005 — edited Dec 10 2005I have 5 tables (or more) in master detail relation (five levels). Is possible to write recursive select cross user_constraints table to get all this levels from select?
my wrong try:
select table_name,R_CONSTRAINT_NAME,CONSTRAINT_NAME from user_constraints a
where a.R_CONSTRAINT_NAME is not null
connect by prior a.CONSTRAINT_NAME=a.r_CONSTRAINT_NAME start with a.R_CONSTRAINT_NAME='ZMPTDOPO_PK';