Obtain data on a connection between two tables HELP!

[TREW]

good!
I need help!
I would like to do a select containing the following data on a connection: the son, daughter, parent table and table id of the connection.
someone could help me?
Thank you very much

[Trevisolli]

Brother, what information do you have?
Name of the child table. The father?

These visions below may help you:

Code: Select all

-- Sessão
SELECT *
FROM v$session;

--Tabelas
SELECT *
FROM user_Tables;

--Constraints/Relacionamentos
SELECT *
FROM user_constraints;