find all tables where column name exists oracle code example

Example: find all tables where column name exists oracle

select table_name from all_tab_columns where column_name like '%STLDOC%';