In my daily work, an important mission is to identify a specific value in a database.
Such as, please find value "XYZ" in owner "DDD", and then, write down the associated table and column names.
If there's an effective method that I can use in Oracle PL/SQL?
I need to do this because I need:
1) define business requirements for ETL;
2) map columns between target schema and destination schema with specific values;
3) write SQL for ETL;