3.63 ALL_ANNOTATIONS

ALL_ANNOTATIONS displays schema annotations accessible to the current user.

Related Views

  • DBA_ANNOTATIONS displays all schema annotations in the database.

  • USER_ANNOTATIONS displays 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

Note:

This view is available starting with Oracle Database 23ai.