Obtain data on a connection between two tables HELP!

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Sun, 06 Apr 2008 5:58 am

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
TREW
Location: SP

Poston Sun, 06 Apr 2008 11:38 am

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;
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP


  • See also
    Replies
    Views
    Last Post


      Return to SQL

      Who is online

      Users browsing this forum: No registered users and 1 guest