Friday, April 13, 2012

How to find a perticular cell value from an entire database?

Today we ran into a strange issue.

We have got an email from an application . The strange fact was the mail sender was an x employee of our organization.

We had to take a decision to change it :) but all we had is database credentials and name of an x employee.


Searching a particular name in entire database seemed a mammoth task if done manually.So we looked here and there.
Finally we got a pl-sql script to accomplish the same.

Please find the below post where i got a solution from experts.
https://forums.oracle.com/forums/thread.jspa?threadID=2374991&messageID=10272629#10272629