1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_ANNOTATION_VALUES

3.57 ALL_ANNOTATION_VALUES

ALL_ANNOTATION_VALUES displays the values for schema annotations accessible to the current user.

Related Views

  • DBA_ANNOTATION_VALUES displays the values for all schema annotations in the database.

  • USER_ANNOTATION_VALUES displays the values for schema annotations owned by the current user. This view does not display the ANNOTATION_OWNER column.

Column Datatype NULL Description

ANNOTATION_OWNER

VARCHAR2(128)

NOT NULL

Annotation owner

ANNOTATION_NAME

VARCHAR2(1024)

NOT NULL

Annotation name

ANNOTATION_VALUE

VARCHAR2(4000)

Annotation value

Note:

This view is available starting with Oracle Database 23ai.

See Also: