List of available usage definitions.
Output
Column | Type | Description |
|---|---|---|
usages_id | NUMBER | Usage primary key. |
name | VARCHAR2 | Name of this usage. |
sequence | NUMBER | Order that the usages are shown in HPD. |
minscale | NUMBER | Minimum scale for this usage. |
maxscale | NUMBER | Maximum scale for this usage. |
writable | VARCHAR2 | 'Y' if the user has write access to the usage. Otherwise 'N'. |
procedure_id | NUMBER | ID of the procedure. Procedures can be created in HPD Admin Tools. |
Example
The following example shows the use of this view in an SQL statement.
select * from usages; |