The PL/SQL code creates dynamic
SQL
to check for data in all the
database
tables that have the column "PART_NUMBER" and
data count of a specific part number. The dynamic SQL uses
the bind variable
i_val
that gets assigned with the input value
v_part
during query execution. The output row count
value gets assigned to the variable
v_count.
Oracle registered trademark of Oracle Corporation.