Here is the sample query to get the metadata details for the Oracle tables.
Note : Please modify as per your requirements accordingly.
SELECT atc.table_name, atc.column_name, atc.*
FROM all_tab_columns atc
WHERE column_name LIKE '%EMPLOYEE%' OR column_name LIKE '%PERSON%';
