Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to search a particular string in whole schema?

BS2012Aug 23 2013 — edited Sep 2 2013

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.

This post has been answered by ora1001 on Aug 27 2013
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 30 2013
Added on Aug 23 2013
32 comments
32,474 views