As far as I know in Microsoft SQL Server it is possible to use CURSOR to "scan" database and get all tables/entries where specified string is mentioned. Can I do this in Oracle 11g DB? Any caveats/limits for such scenario?
I'm hard-pressed to imagine how you'd accomplish that with a single cursor in SQL Server.
In either case, the result is going to be insanely slow since you're full scanning every table at least if not once per character column.