Illustration repln080.gif 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.world |
| 118 | Klein | 22 Iris Ln. | Planes, NE | houston.world |
| 121 | Lee | 71 Blue Ct. | Aspen, CO | houston.world |
| 204 | Potter | 181 First Av. | Aspen, CO | houston.world |
| . | . | . | . | . |
| . | . | . | . | . |
| . | . | . | . | . |
DBA_REPPRIORITY data dictionary view:
... |
PRIORITY_GROUP |
PRIORITY |
... |
VARCHAR2_VALUE |
|---|---|---|---|---|
| . | site-priority | 1 | . | houston.world |
| . | site-priority | 2 | . | new_york.world |
| . | order-status | 1 | . | ordered |
| . | order-status | 2 | . | shipped |
| . | order-status | 3 | . | billed |
| . | . | . | . | . |