Annotations

Oracle Database annotations, a new Oracle Database 23ai feature, allow storing database object metadata. They comprise a name, commonly called a key, and an optional value. Both are freeform text fields. A schema object can have more than one annotation.

ODP.NET Core, managed, and unmanaged drivers all support Oracle Database annotations in table and view columns. ODP.NET materializes them as JSON formatted strings in those schema objects.

ODP.NET can retrieve database annotations using OracleDataReader.GetSchemaTable. The SchemaTable has one column, Annotations, that stores this information as JSON formatted string.