List all the constraint of a database

I would like to list all the referential intergrity attach to a table.

I know I can do this to list them :
select table_name from all_constraints
where R_constraint_name like 'name of the constarint'

But I want to have also the listing of refenrential (indirect : made thought an other table :table1-table2-table3)

Anyone to help me

ROdrigues Richard

--
Posted via CNET Help.com
http://www.help.com/