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
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? Received on Mon Oct 03 2005 - 15:12:39 CDT