Re: Find database objects in Oracle

On Thu, 05 Jan 2006 10:08:20 -0500, Mark C. Stock wrote:

> 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 http://tahiti.oracle.com) 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
>

(I suspect he wants to look at ALL_TAB_COLUMNS and pull out the tablename. Too bad he's a top poster who ignores .sigs) Received on Thu Jan 05 2006 - 16:49:44 CET