DBA Data[Home] [Help]

VIEW: XDB.JSON$USER_COLLECTION_METADATA

Source

View Text - Preformatted

select URI_NAME,
       OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME,
       CREATED_ON, CREATE_MODE, JSON_DESCRIPTOR
  from XDB.JSON$COLLECTION_METADATA
 where OWNER = USER
View Text - HTML Formatted

SELECT URI_NAME
, OBJECT_TYPE
, OBJECT_SCHEMA
, OBJECT_NAME
, CREATED_ON
, CREATE_MODE
, JSON_DESCRIPTOR
FROM XDB.JSON$COLLECTION_METADATA
WHERE OWNER = USER