Oracle教程 2023-04-06

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

本站中文解释

Oracle视图ALL_BLOCKCHAIN_TABLES是一个可以供所有用户查看和使用的系统视图，其中包含了存储在Oracle Blockchain Data Service中的每一个表的基本信息。ALL_BLOCKCHAIN_TABLES视图可以让用户查看表中的结构，查看和修改数据，什么时候和谁对数据做过修改等，有利于快速检索和管理用户的测试和生产链上数据。

要使用ALL_BLOCKCHAIN_TABLES视图，只需以普通SQL SELECT命令完成即可，如：

SELECT * FROM ALL_BLOCKCHAIN_TABLES;

官方英文解释

ALL_BLOCKCHAIN_TABLES describes the blockchain tables accessible to the current user.

Related Views

DBA_BLOCKCHAIN_TABLES describes all blockchain tables in the database.
USER_BLOCKCHAIN_TABLES describes the blockchain tables owned by the current user. This view does not display the SCHEMA_NAME column.

Column	Datatype	NULL	Description
`SCHEMA_NAME`	`VARCHAR2(128)`	`NOT NULL`	The schema containing the blockchain table
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the blockchain table
`ROW_RETENTION`	`NUMBER`		Row retention period for the blockchain table, that is, the minimum number of days a row must be retained and cannot be deleted after it is inserted into the table If the value of this column is NULL, then rows can never be deleted from the table.
`ROW_RETENTION_LOCKED`	`VARCHAR2(3)`		Indicates whether the row retention period for the blockchain table is locked. Possible values: `YES`: The row retention period is locked. You cannot change the row retention period `NO`: The row retention period is not locked. You can change the row retention period to a value higher than the current value with the SQL statement `ALTER` `TABLE` … `NO` `DELETE` `UNTIL` `n` `DAYS` `AFTER` `INSERT`
`TABLE_INACTIVITY_RETENTION`	`NUMBER`		Number of days for which the blockchain table must be inactive before it can be dropped, that is, the number of days that must pass after the most recent row insertion before the table can be dropped A table with no rows can be dropped at any time, regardless of this column value.
`HASH_ALGORITHM`	`VARCHAR2(8)`		Algorithm used for computing the hash value for each table row

本站中文解释

官方英文解释

相关推荐