Re: Find database objects in Oracle

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 5 Jan 2006 10:08:20 -0500
Message-ID: <>

<> wrote in message
> Hi I want to find a field that holds the doctors name in a database. I
> want to do a wildcard search by field name like %doc% or %phy%. This
> is something I would do in SQL Server but I am not familiar with
> oracle. Can you search by field name in Oracle?
> Any suggestions would be greatly appreciated.
> Thanks
> Ross

[Quoted] write a query against data dictionary views USER_TAB_COLUMNS, ALL_TAB_COLUMNS, or DBA_TAB_COLUMNS (check out difference in scope in the Referene manual at to find tables that contain the columns of interest

note that object and column names are stored in the data dictionary in upper case, unless the name was enclosed in "double quotes" when the object created

++ mcs Received on Thu Jan 05 2006 - 16:08:20 CET

Original text of this message