Oracle SQL selects to get familiar with table naming standard and to find junk tables in scheme

Run following selects to discover prefix and suffix hierarchies and to get count of particular prefix/suffix occurrences. That will help you become familiar with naming standard and to find suspicious prefixes/suffixes that belong to tables that probably store junk data.

Oracle: Case insensitive regexp search through all sources

select *
from all_source
where regexp_like( text, regexp_search_string, 'i' )