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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Find database objects in Oracle

Re: Find database objects in Oracle

From: HansF <News.Hans_at_telus.net>
Date: Thu, 05 Jan 2006 15:49:44 GMT
Message-ID: <pan.2006.01.05.15.49.44.555596@telus.net>


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 - 09:49:44 CST

Original text of this message

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