CODE EXAMPLE FOR SQL

find all tables where column name exists oracle

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