Skip to Main Content
Forums

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!

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

Srini Chavali-Oracle
Currently, RHEL 6 is not a certified platform to install either 10g or 11g

Check the certification matrix in MOS for updates

HTH
Srini
Shivananda Rao
Please refer the MOS document *Certification Information for Oracle Database on Linux x86 [ID 1307056.1]*

OEL 6 is not certified to install Oracle Database
Helios-GunesEROL
Hi;
Is it fine to install oracle 10g and 11g on RHEL 6?
Its not certified as mention. But if you want to make installation on that release see Tim's site:

http://www.oracle-base.com/blog/2011/02/13/oracle-11gr2-on-oracle-linux-6/

Regard
Helios
1 - 3
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
33,512 views