ALL_JSON_COLLECTION_TABLES
ALL_JSON_COLLECTION_TABLES describes JSON collection tables accessible to the current user.
Related Views
-
DBA_JSON_COLLECTION_TABLESdescribes all JSON collection tables in the database. -
USER_JSON_COLLECTION_TABLESdescribes 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 AI Database 26ai.
See Also: