The SQL code shows the map names assigned to the usages.
SQL>col usage_name format a40 SQL>map_name format a20 SQL>select usages_id, name usage_name, 'U'||usages_id map_name from usages; |
Example data is shown below.
USAGE_ID USAGE_NAME MAP_NAME |
---------- -------------------------------- |
1 Berthing(1-2499) U1 |
2 Harbour(2500-4999) U2 |
3 Approach(5000-34999) U3 |
4 Coastal(35000-99999) U4 |
5 General(100000-499999) U5 |
6 Overview(500000-10000000) U6 |
6 rows selected |