View chart attribute values.
UNDEFINED attributes are not shown in this view. UNKNOWN values are represented by a NULL in both value fields.
The definition of the attributes can be found in the Catalogue Editor.
Output
Column | Type | Description |
|---|---|---|
chartver_id | NUMBER | Primary key of the chart version. |
acronym | VARCHAR2 | Aattribute acronym. |
stringval | VARCHAR2 | Value of the attribute, if it is a string. |
numberval | NUMBER | Value of the attribute, if it is a number. |
sequence | NUMBER | Used to sequence multiple values for the same attribute. This is used for list values and long string values. |
Example
The following example shows the use of this view on an SQL statement.
select chartver_id from CHART_ATTRIBUTES_VIEW WHERE acronym = 'CHTNUM' and stringval = '1234'; |
Exceptions
None defined at this time.