This illustration shows the customer table and the DBA_REPPRIORITY data dictionary view.

customer Table:

custno name addr1 addr2 site
153 Kelly 104 First St. Jones, NY new_york.example.com
118 Klein 22 Iris Ln. Planes, NE houston.example.com
121 Lee 71 Blue Ct. Aspen, CO houston.example.com
204 Potter 181 First Av. Aspen, CO houston.example.com
. . . . .
. . . . .
. . . . .

DBA_REPPRIORITY data dictionary view:

... PRIORITY_GROUP PRIORITY ... VARCHAR2_VALUE
. site-priority 1 . houston.example.com
. site-priority 2 . new_york.example.com
. order-status 1 . ordered
. order-status 2 . shipped
. order-status 3 . billed
. . . . .