Displays information about text features in the common feature storage. Any spatial representation can be queried, including obsolete versions. See also FEATURE_GEOMETRY_VW for more information.
Output
Column | Type | Description |
|---|---|---|
rep_id | NUMBER | The spatial representation id. This represents the geometry. |
text | CLOB | The text as an RTF string. |
Example
select sv.rep_id, g.lldg_geom, g.branch_geom, txt.text from source_feature_vw sv, feature_geometry_vw g, feature_geometry_text_vw txt where sv.rep_id = g.rep_id and sv.rep_id = txt.rep_id and sv.foid = FoidStringToNumber('1C 0000000001 00001'); |