Hi Everyone,
My DB version is
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
"CORE 10.2.0.1.0 Production"
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
Suppose I have a column say "EMAIL_ID" in employee table. The employee name is "abcd" and his email_id is "abcd@alphabets.com".
The column name is changing from "EMAIL_ID" to "EMAIL_ADDRESS" due to poor naming convention standard.
Now I've only one constant value i.e. "abcd@alphabets.com"...So is there any way if I will write a query with this value and I'll get the list of
tables and the exact column name where this mail_id exists?
Regards,
BS2012.