I doubt there is a way to do it mostly because creating/dropping is not something that should be done frequently (such that optimization is really necessary).
If you're in a situation where tables need to be dropped often (especially 200), I'd wonder if
you should rethink your schema. BTW, even if you can't do this in PLSQL, you can always do what your describing pretty easily in
JDBC just using a while loop on the first SELECT statement, but again, I'd wonder more about why this is necessary.