orafind – Finding records in a schema
Purpose
orafind can be used to search all tables in an Oracle database schema for a string.
Options
orafind supports the following options:
- tables
Zero or more tables names. If any table names are specified the search will be limited to those tables. Otherwise all tables will be searched.
- -v <flag>, --verbose <flag>
Produces output (on stderr) while the database is read or written. (Valid flag values are
false
,no
,0
,true
,yes
or1
)
- -c <mode>, --color <mode>
Should the output (when the
-v
option is used) be colored? Ifauto
is specified (the default) then the output is colored if stderr is a terminal. Valid modes areyes
,no
orauto
.
Example
Search for spam
in all tables in the schema user@db
. The search is case
insensitive and CLOB
s will be printed:
$ orafind user/pwd@db spam -i -r