Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB 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.

The same question has been asked and answered on StackOverflow.  If you want to get really tricky, you could also use an XML Query to search across objects with a single query.

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.