Oracle教程 2023-04-05

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

：

ALL_LOG_GROUP_COLUMNS是Oracle中表示基于群组的日志结构的一个固有视图。这个Oracle的视图可以显示一个组和每个组中的当前列的列信息。这些群组引用一个参考表列，每个引用群组中的表列有一个栏位列信息，也是在这个视图中显示出来的。

用法：可以使用ALL_LOG_GROUP_COLUMNS视图来查询应用到组中的列结构信息。例如，可以创建以下查询以查看群组x中列的信息：

SELECT * FROM all_log_group_columns where group_name = ‘x’;

ALL_LOG_GROUP_COLUMNS describes columns that are accessible to the current user and that are specified in log groups.

Related Views

DBA_LOG_GROUP_COLUMNS describes all columns in the database that are specified in log groups.
USER_LOG_GROUP_COLUMNS describes columns that are owned by the current user and that are specified in log groups.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the log group definition
`LOG_GROUP_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the log group definition
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table in which the log group is defined
`COLUMN_NAME`	`VARCHAR2(4000)`		Name of the column or attribute of the object type column specified in the log group definition
`POSITION`	`NUMBER`		Original position of the column or attribute in the definition of the object
`LOGGING_PROPERTY`	`VARCHAR2(6)`		Indicates whether the column or attribute would be supplementally logged (`LOG`) or not (`NO LOG`)