I want to do something similar to this

select *
from (select table_name table from user_tables)
where (desc table) like '_%'

but I know I cant run the (desc table) part - I want to do something like that.

I want to have all the fields in the where clause and I dont want to have to type them all out (if possible)

I do realise that this query will take a long long time to actually execute and I do know that the subquery will only search for tables available to the user that is logged in