Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Finding tables that contain a certain column value
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.
-- 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=895641Received on Fri Sep 30 2005 - 13:36:24 CDT