Trying to use all_tab_columns to drive another sql - please help?

Hi,

I have all the table names of all the tables that contain an given field.

select table_name
from all_tab_columns
where column_name = 'COL_A';

This gives me over 400 tables back. What I now need to do is check each of these tables for a given value for COL_A.

I don't know how to code a procedure in pl\sql that will loop through my cursor and use the INTO variables as the table_name in a from clause.

Does anyone know how I can go about doing this? I have tried to search but my keywords return very generic and unhelpful results.

Thanks

hi ..
use currsors.......