SQL & PL/SQL

There is a requirement for searching a value in DB. i.e. Scanning each table for a value.
e.g. We want to search a string value ‘Ranjeet’.

The result should give us: Table name & Column name where the value is found.
Also, the script should show it’s progress to us and shouldn’t get hanged somewhere…or make the DB down.