home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 2,240 of 2,288   
   Svend Jensen to Fred Wilson   
   Re: Finding all tables with a particular   
   14 Oct 06 15:04:21   
   
   From: Svend.JensenSPAMKILL@secret.dk   
      
   Fred Wilson wrote:   
   > Hello,   
   >   
   > How does one go about finding all the tables that have a particular   
   > field name? For example a field name "EVENT_CODE"   
   >   
   > I would like to find all the places in the database this is located.   
   > Ultimately I want to further find in that field the code "0214" and   
   > change it to "0200".   
   >   
   > Thank you,   
   > Fred   
   Check the views user/all/dba_tab_columns   
      
   Rgds   
      
   Svend   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca