Oracle教程 2023-02-24

Oracle 视图 USER_SODA_COLLECTIONS 官方解释，作用，如何使用详细说明

Oracle视图 USER_SODA_COLLECTIONS 用于提供用户下创建的共享型对象存储（SODA）集合的元数据信息，如配置参数、创建者以及创建时间等。使用此视图的目的是以采用常规ADO.NET模式为准则来了解共享型对象存储（SODA）集合的概念。

使用USER_SODA_COLLECTIONS视图可以查询当前用户所创建的SODA集合的相关元数据信息，包括：

1) COLLECTION_NAME：集合的名称；
2) OWNER：集合的创建者；
3) CREATED：集合创建的时间；
4) CONFIG：集合创建时使用的JSON配置参数；

使用示例：

SELECT *
FROM USER_SODA_COLLECTIONS
WHERE OWNER = ‘SCOTT’

USER_SODA_COLLECTIONS displays information about Simple Oracle Document Access (SODA) collections.

Column	Datatype	NULL	Description
`URI_NAME`	`NVARCHAR2(255)`	`NOT NULL`	Collection name
`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)

分享到：