#a subquery

Is it possible to select from multiples tables, having theirs names as the result of a subquery?

I have some tables with the same structure and I want to make a select in a group of them.

Rather than just making a loop to all of those tables, I would like to put a subquery after the FROM of the main query.

Is it possible or it will fail?

Thanks!

(Using Oracle)

Additional info: I don’t have the name of the table right away! They’re stored in another table. Is it possible to have a subquery…