|
Visual Expert for PL/SQL - Impact analysis for a Database Column
In this example, we are looking for references to the column "id"
from the table "product" (displayed as "product.id").
As a result, Visual Expert lists a stored procedure, 3 triggers, 1 block and 2 cursors
using this column. The source code view (on the right) displays the code of
a SQL statement defined in a procedure and referencing the column "id". |