"" wrote:
> On 30 Sep 2005 14:36:24 -0400, Raptor
> <UseLinkToEmail_at_dbForumz.com> wrote:
>
> >I’m currently working in Oracle 8i and I’m attempting to
> write an SQL
> >statement to provide a listing of tables where the
> column_name
> >contains a certain value, but I’m not having any luck.
> >
> >I can obtain a listing of all the availabe tables with the
> column I’m
> >looking for, but I cannot filter the listing further for just
> the
> >column value.
> >
> >select table_name from all_tab_columns
> >where column_name = ’JCN’;
> >
> >I now need to filter the listing further to just those tables
> that
> >contain the correct value in JCN
> >
> >Any help would be appreciated.
> Hi.
> I am not an expert, but I think that it depends on your
> environment.
> the ps sql solution is great.
>
> maybe a batch file solution would fit also, where you spool
> your output of one
> query into a file and then run that file.
>
> what are your constraints in a developement and runtime manner
> of speaking?
No constraints, just wanted a somewhat simple query to aid the DBA in
locating the tables in which the data they are looking for is stored.
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Oracle-Finding-tables-column-ftopict259881.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=898284
Received on Tue Oct 04 2005 - 14:41:29 CDT
