3.263 ALL_JSON_COLLECTIONS

ALL_JSON_COLLECTIONS describes JSON collections accessible to the current user.

Related Views

• DBA_JSON_COLLECTIONS describes all JSON collections in the database.

• USER_JSON_COLLECTIONS describes JSON collections owned by the current user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)		Name of the JSON collection owner
COLLECTION_NAME	VARCHAR2(128)		Name of the JSON collection
COLLECTION_TYPE	VARCHAR2(12)		Type of the JSON collection: TABLE VIEW DUALITY VIEW

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_JSON_COLLECTIONS"

• "USER_JSON_COLLECTIONS"