I'm trying to write query that gets it's table names from a sub query.
I tried Select * from TABLE(Select tablename from tablename where x=foo)
and I get and error: [Oracle][ODBC][Ora]ORA-22905:cannot access rows from a non-nested table item
I tried Select * from (Select tablename from tablename where x=foo) T
and get no error but there are not fields avaiable