$sth = $dbh->prepare('SELECT * 
                      FROM   all_tables 
                      WHERE  table_name = ?');

$sth->execute($table_name);

while (@row = $sth->fetchrow_array) {
    print "@row\n";
}