VIEW: MDSYS.ALL_ANNOTATION_TEXT_METADATA

Source

View Text - Preformatted

SELECT F_TABLE_SCHEMA OWNER, F_TABLE_NAME TABLE_NAME,
               F_TEXT_COLUMN COLUMN_NAME,
               MAP_BASE_SCALE,
               TEXT_DEFAULT_EXPRESSION TEXT_EXPRESSION,
               TEXT_DEFAULT_ATTRIBUTES TEXT_ATTRIBUTES
FROM SDO_ANNOTATION_TEXT_METADATA, ALL_OBJECTS a
       where a.object_name = F_TABLE_NAME and a.owner = F_TABLE_SCHEMA
             and a.object_type in ('TABLE', 'SYNONYM', 'VIEW')

View Text - HTML Formatted

SELECT F_TABLE_SCHEMA OWNER
, F_TABLE_NAME TABLE_NAME
, F_TEXT_COLUMN COLUMN_NAME
, MAP_BASE_SCALE
, TEXT_DEFAULT_EXPRESSION TEXT_EXPRESSION
, TEXT_DEFAULT_ATTRIBUTES TEXT_ATTRIBUTES FROM SDO_ANNOTATION_TEXT_METADATA
, ALL_OBJECTS A
WHERE A.OBJECT_NAME = F_TABLE_NAME
AND A.OWNER = F_TABLE_SCHEMA
AND A.OBJECT_TYPE IN ('TABLE'
, 'SYNONYM'
, 'VIEW')