Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Find all tables with a particular field

Re: Find all tables with a particular field

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 19 Sep 2006 14:01:30 -0700
Message-ID: <1158699688.258834@bubbleator.drizzle.com>


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
Received on Tue Sep 19 2006 - 16:01:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US