View feature attributes.
If the returned clob is greater than 4000 bytes then it must be handled with package DBMS_LOB.
Output
Column | Type | Description |
|---|---|---|
attribute_class | NUMBER | The id of the attribute from the catalogue |
acronym | VARCHAR2 | The attribute acronym |
featver_id | NUMBER | The primary key of the feature version that the attribute belongs to |
type | VARCHAR2 | Type of attribute defined in attribute_type. The following values are used: • S: string • L: list • A: alphanumeric • E: enumeration • W: date • I: integer • F: float • T: text (reference to a file) • R: raster (reference to a file) |
data | CLOB | The attribute value |
unknown | CHAR | 'Y' if the value is UNKNOWN. Otherwise 'N'. |
Example
-- Get current attributes for FOID 1C 0000000001 00001 in HPD Source select acronym, featver_id, DATA, UNKNOWN from FEATURE_ATTRIBUTE_VW where featver_id in (select featver_id from SOURCE_FEATURE_VW where foid = FoidStringToNumber('1C 1 1')); |