Purpose

orafind can be used to search all tables in an Oracle database schema for a string.

Options

orafind supports the following options:

connectstring: An Oracle connectstring.
searchstring: The text to be searched for.
tables: Zero or more tables names. If any table name is specified the search will be limited to those tables. Otherwise all tables will be searched.
-v, --verbose (false, no, 0, true, yes or 1): Produces output (on stderr) while the database is read or written.
-c, --color (yes, no or auto): Should the output (when the -v option is used) be colored? If auto is specified (the default) then the output is colored if stderr is a terminal.
-i, --ignore-case (false, no, 0, true, yes or 1): If given, the search will be case insensitve.
-r, --read-lobs (false, no, 0, true, yes or 1): If given, CLOBs will be read when printing search results.

Search for spam in all tables in the schema user@db. The search is case insensitive and CLOBs will be printed:

$ orafind user/pwd@db spam -i -r