Media Type Column Name

The collection metadata component that specifies the name of the column that stores the media type of the document. A media type column is needed if the collection is to be heterogeneous, that is, it can store documents other than JavaScript Object Notation (JSON).

Note: You cannot use query-by-example (QBE) with a heterogeneous collection. An error is raised if you try to do so.

Property Value
Default value None
Allowed values Valid Oracle quoted identifier1 (as defined in Oracle Database SQL Language Reference). If this value contains double quotation marks (") or control characters then SODA replaces them with underscore characters (_).
JSON collection metadata document path mediaTypeColumn.name
  1. Reminder: letter case is significant for a quoted SQL identifier; it is interpreted case-sensitively.