1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_JSON_COLLECTION_TABLES

3.267 ALL_JSON_COLLECTION_TABLES

ALL_JSON_COLLECTION_TABLES describes JSON collection tables accessible to the current user.

Related Views

  • DBA_JSON_COLLECTION_TABLES describes all JSON collection tables in the database.

  • USER_JSON_COLLECTION_TABLES describes JSON collection tables owned by the current user.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Name of the JSON collection table owner

COLLECTION_NAME

VARCHAR2(128)

NOT NULL

Name of the JSON collection table

WITH_ETAG

VARCHAR2(3)

Indicates whether the JSON collection table was created with the ETAG option (YES) or not (NO)

Note:

This view is available starting with Oracle Database 23ai.

See Also: