Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Finding tables that contain a certain column value
Raptor wrote:
> "" 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.
Jumping into this in the middle I'll grant. But if your DBA can't do this without help ... you need to let this person fail and get a qualified DBA.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Oct 04 2005 - 16:06:26 CDT