この図は、customer表とDBA_REPPRIORITYデータ・ディクショナリ・ビューを示しています。
customer表:
| 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データ・ディクショナリ・ビュー:
| ... | 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 |
| . | . | . | . | . |