DBA_SODA_COLLECTIONS

DBA_SODA_COLLECTIONS describes all Simple Oracle Document Access (SODA) collections in the database.

USER_SODA_COLLECTIONS describes the SODA collections owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
URI_NAME NVARCHAR2(255) NOT NULL Collection name
OWNER VARCHAR2(128) NOT NULL Owner of the collection
OBJECT_TYPE VARCHAR2(10) NOT NULL Indicates whether the collection is table-based (TABLE) or view-based (VIEW)
OBJECT_SCHEMA VARCHAR2(128) NOT NULL Name of the schema that includes the table or view on which the collection is based
OBJECT_NAME VARCHAR2(128) NOT NULL Name of the table or view on which the collection is based
CREATED_ON TIMESTAMP(6) NOT NULL Collection creation time
CREATE_MODE VARCHAR2(10) NOT NULL

Creation mode. Possible values:

  • DDL: A new table was created at collection creation time
  • MAP: The collection was created by mapping a preexisting table or view

Note: For view-based collections, the value of this column is always MAP. New views are not created for view-based collections. A view-based collection is always created by mapping a preexisting view.

JSON_DESCRIPTOR VARCHAR2(4000) NOT NULL Collection metadata, expressed in JavaScript Object Notation (JSON)

See Also: “USER_SODA_COLLECTIONS”