Skip to Main Content

Tables & Columns

Column NameTable NameData TypeComments
DISPOSITIONTEDSTRUIK.TED_MAIL_TEST_PARTSVARCHAR2(100) 
FILENAMETEDSTRUIK.TED_MAIL_TEST_PARTSVARCHAR2(100) 

Package Dependencies 1

Object NameObject TypeTc Table NameTc MaskS LinenumbersS Lines
TEDSTRUIK / TED_MAILPACKAGE BODYTEDSTRUIK / TED_MAIL_TEST_PARTS%disposition%280, 283, 284, 285, 286, 287, 379, 388, 401, 418, 420, 516, 534, 574, 607, 608, 609, 610, 611, 622, 637, 638, 639, 640, 641, 663, 664, 684, 688, 698, 699, 700, 704
TEDSTRUIK / TED_MAILPACKAGE BODYTEDSTRUIK / TED_MAIL_TEST_PARTS%filename%203, 284, 573, 608, 638, 684, 688, 695, 699, 706
TEDSTRUIK / TED_MAIL_OLDPACKAGE BODYTEDSTRUIK / TED_MAIL_TEST_PARTS%disposition%223, 226, 227, 228, 229, 230, 325, 329, 335, 337, 433, 451, 489, 522, 523, 524, 525, 526, 537, 552, 553, 554, 555, 556, 578, 579, 599, 603, 613, 614, 615, 619
TEDSTRUIK / TED_MAIL_OLDPACKAGE BODYTEDSTRUIK / TED_MAIL_TEST_PARTS%filename%146, 227, 488, 523, 553, 599, 603, 610, 614, 621

Info

Packages and the tables & columns they reference, take 1. Click here for take 2.

A method to find out which packages reference which columns. It's not always perfect (because it uses text matching it tends to find too much), but I have found it to be very useful when trying to find out what impact a table/column change is likely to have.

See the package code for more details.
In this example, we're looking for packages that either reference columns named like '%employee_id%' or '%department_id%', or the 'disposition' or 'filename' columns in table 'ted_mail_test_parts'. You'll want to adjust the where clauses to your needs.

Either run this as sys/system, or give the user these privileges:

Code

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source

Package

Package
Name
Source

Package Body

Package Body
Name
Source