Finding a table name

select *
from dba_tables
where table_name like '%<table_name>';