sure,
but i can only give you an example and i don't know if it's the best way.
$tables = array('table1','table2'); // here place all your tables you
// want to search or make an selection with
/*
SELECT * FROM user_tables;
that will get all your tables in place 2 of the returning array
*/
while(
$get_colum_names = "DESC ".$tables[$i];
$get_c_n = OCIParse($db, $get_column_names);
OCIExecute($get_c_n);
while(OCIFetchinto($get_c_n, $col, OCI_NUM))
$col_nam[] = $col[1];
$search = "SELECT * FROM ". $tables[$i] ."
WHERE ". $col_nam[$m] ." = ". $requirement;
$search_p = OCIParse($db, $search);
OCIExecute($search_p);
OCIFetchinto($search_p, $row, OCI_NUM);
echo $row[0];
hopes that works fine... have phun...