| The Database
Scanner is designed to search one or
all of the tables on your database for possible
violations. It may be configured to identify a particular
date or date range, so that you can determine if
your applications are writing or using invalid dates
in the database. It may also be configured to uncover
SQL and PL/SQL using non-compliant date formats
embedded in your database. In addition, it can be
configured to search and report on any pattern,
value or value range in your database.
The Scanner uses a sophisticated
PL/SQL engine to scan user-defined sources in
the database. The user defines search patterns
or targets in the form of a SQL where clause.
As the scanner reads each source table, it logs
the table_name.column_name for each instance that
it encounters a target match. These matches are
referred to as "hits." Additionally,
the user may define particular objects to exclude
from the scan. You may want to ignore particular
tables that have already been scanned, or avoid
wasting scan resources on a custom table that
does not exist in your production database.
In addition, Scanner comes pre-configured to identify
most possible non-compliant data. Therefore, it
can immediately be used to identify tables in
your database that contain non-compliant data.
It is also a highly effective tool to audit unit/integration
testing.
|
