select data from user_cons,user_constraints,user_cons_columns
dear sirs, i want to select table name and its referencial tables and constraint_names and column which used in this constraints referencial
i use this select but it seems not right
select t.table_name,t.ref_name,c.constraint_name,m.column_name
from user_cons t,user_constraints c,user_cons_columns m
where
c.table_name = t.table_name
and m.table_name = c.table_name
and m.constraint_name = c.constraint_name
and constraint_type ='R'
and c.table_name like 'STK%'
order by table_name,constraint_name
please help me
yasser