Plsql search tables

Search all tables.

select * 
from all_tables
where 1=1
and owner = 'OWNER'
and table_name LIKE '%%';