Re: Find database objects in Oracle

From: HansF <>
Date: Thu, 05 Jan 2006 15:49:44 GMT
Message-ID: <>

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 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

Original text of this message