Query field names in tables

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

Poston Tue, 17 Apr 2007 4:21 pm

Good afternoon.

I wonder how do you min search name field of all tables of an oracle database. Exe: I look for a field named balance, this field can be in various tables in the Bank and I want to know all tables on which the name or% balance balance% appears.

Thank you
rickab7
Location: campo grande

stephany henrique de almeida batista

Poston Tue, 17 Apr 2007 5:08 pm

There you go girl ...

Code: Select all

SELECT *
  FROM all_tab_columns
WHERE upper(column_name)  LIKE '%TESTE%'


Trevisolli
Location: Araraquara - SP

Abraço,

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

Poston Tue, 17 Apr 2007 6:32 pm

Boy you broke a tree to min. ..Thanks and God bless q hehehehhe você and the todos family
rickab7
Location: campo grande

stephany henrique de almeida batista

Poston Wed, 18 Apr 2007 9:02 am

Imagine needing, we aí.
Stay with God.
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