Escape in SQL

Below is one example to use escape in SQL(Oracle).

select * from all_tables where table_name like '%TEST/_%TABLE%' ESCAPE '/';