Oracle 视图 ALL_APPLY_TABLE_COLUMNS 官方解释，作用，如何使用详细说明
本站中文解释
列表
Oracle视图ALL_APPLY_TABLE_COLUMNS (可能也称为DBA_APPLY_TABLE_COLUMNS)描述了当前所有可用定义的 Streams 和 Advanced Queue (AQ) 应用的字段的信息。此视图针对字段元数据，如数据类型、长度、精度、默认值等提供了快速和易于查询的访问方式。
此视图可以用于建立字典以及验证列是否存在于定义的Streams应用中。
要使用此视图，需要执行以下步骤：
1.连接到Oracle服务器。
2.查询ALL_APPLY_TABLE_COLUMNS视图，输入要查找的表名，可以获得这个表所有定义的列的信息：
SELECT * FROM ALL_APPLY_TABLE_COLUMNS WHERE TABLE_NAME = ‘TABLE_NAME’;
3.获取字段元数据信息，如数据类型，长度以及默认值。
官方英文解释
ALL_APPLY_TABLE_COLUMNS displays, for the tables accessible to the current user, information about the nonkey table columns for which apply process conflict detection has been stopped for update and delete operations.
Conflict detection for nonkey columns can be stopped using the DBMS_APPLY_ADM.COMPARE_OLD_VALUES procedure.
Related View
DBA_APPLY_TABLE_COLUMNS displays, for all tables in the database, information about the nonkey table columns for which apply process conflict detection has been stopped for update and delete operations.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the table |
|
|
|
|
Name of the table |
|
|
|
|
Name of the column |
|
|
|
|
Indicates whether to Compare the old value of the column on deletes ( |
|
|
|
|
Indicates whether to Compare the old value of the column on updates ( |
|
|
|
|
For remote tables, name of the database link pointing to the remote database |
See Also:
-
“DBA_APPLY_TABLE_COLUMNS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_APPLY_ADM.COMPARE_OLD_VALUESprocedure
