Re: How do you search through multiple tables?

Not sure how to do it in PLSQL, but in perl, you could do a

$SQL= "select table_name from user_tables
(optional)
where table_name like '%your_50_tables%' "

$dbh->do($SQL);

while((@row) = $sph->fetchrow_array())
  {
# then have it into a variable and use the variable in your next sql:

  $SQL = "select field1 from $row[0] where field2 like '%string to search for%' ";

# send query to do and get back answer.   }

something like that. get answer from first query, use it to make second query. Unfortunatly for perl, you have to have the BDI and the DBD installed. but the same concept can be used for Pro*C or anything else (probably PL/SQL as well) Hope this helps, mail me if more is needed.

Richard Received on Wed Feb 19 2003 - 05:07:21 CST