3.280 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: