View Single Post

   
  #7 (permalink)  
Old 02-25-2008, 08:13 AM
DA Morgan
 
Posts: n/a
Default Re: Find all tables with a particular field

Mark D Powell wrote:
> DA Morgan wrote:
>> Mark D Powell wrote:


>>> You can find documentation on all the Oracle provided dictionary views
>>> in the Oracle Reference Manual along with sections on the database
>>> parameters and the dynamic performance views.
>>>
>>> HTH -- Mark D Powell --

>> I am sure it is a typo Mark but all the tables with a particular column
>> name are likely not going to show up in tab_comments ... rather tab_columns.
>>
>> In most databases no one will put anything in tab_comments. ;-) C'est
>> dommage.
>> --
>> Daniel Morgan
>> Puget Sound Oracle Users Group

>
> Yep, just finished fixing a couple of table comment statements so
> naturally my fingers and brain were following different paths.
>
> HTH -- Mark D Powell --


Trying to earn the "good programmer" award? ;-)

You're going to make the rest of us look like what we are. :-(
--
Puget Sound Oracle Users Group
Reply With Quote