col search_condition format a54
select table_name,constraint_name from user_constraints 
where constraint_type ='R' and constraint_name in (select constraint_name from user_cons_columns where column_name='&1');


select rpad(child.table_name,25,' ') child_tablename,
rpad(cp.column_name,17,' ') referring_column,rpad(parent.table_name,25,' ') parent_tablename,
rpad(pc.column_name,15,' ') referred_column,rpad(child.constraint_name,25,' ') constraint_name 
from user_constraints child,user_constraints parent,user_cons_columns cp,user_cons_columns pc 
where child.constraint_type = 'R' and child.r_constraint_name = parent.constraint_name and
child.constraint_name = cp.constraint_name and parent.constraint_name = pc.constraint_name and
cp.position = pc.position and child.table_name ='&table_name'
order by child.owner,child.table_name,child.constraint_name,cp.position; 

版权声明：本文为博主原创文章，未经博主允许不得转载。