Oracle教程 2023-02-24

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

V$TSDP_SUPPORTED_FEATURE视图显示Oracle数据库支持的所有特性列表，及其相关版本。此视图提供有关Oracle数据库支持的最新特性的信息，所有特性均列为可用和非可用两个状态。

使用方法：

1.可以查询某特性是否支持：

SELECT * FROM V$TSDP_SUPPORTED_FEATURE
WHERE FEATURE = ‘FeatureName’

2.查询所有支持的特性：

SELECT * FROM V$TSDP_SUPPORTED_FEATURE
ORDER BY FEATURE;

V$TSDP_SUPPORTED_FEATURE displays information about the features supported by Transparent Sensitive Data Protection (TSDP).

Column	Datatype	Description
`FEATURE_NAME`	`VARCHAR2(200)`	The name of the supported feature
`FUNCTIONALITY`	`VARCHAR2(200)`	The functionality that is supported within the feature. If all of the functionality of the feature is supported, the value is `ALL`, otherwise the value will show the specific functionality that is supported.
`COMMENTS$`	`VARCHAR2(4000)`	More information regarding the support for the feature and the specific functionality
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data