Oracle 视图 ALL_XSTREAM_TRANSFORMATIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_XSTREAM_TRANSFORMATIONS用于查询系统中所有可用于 XStream 流式处理的转换信息。
该视图描述XStream 可用的类型，其中包括:
* TRANSFORMATION_NAME ：转换的名称
* SOURCE_TABLE_NAME：源表名称
* TRANSFORMATION_TYPE：类型，常用于XSTREAM 行转列
* TRANSFORMATION_FUNCTION：转换函数名称，用于填充
* COLUMN_LIST：字段列表，表示源表中要转换的列
* SCHEMA_NAME：模式名称
使用方法:
使用ALL_XSTREAM_TRANSFORMATIONS视图将需要的字段列表从源表转换到目标表中，可以使用以下sql语句:
“`
SELECT TRANSFORMATION_FUNCTION, COLUMN_LIST
FROM ALL_XSTREAM_TRANSFORMATIONS
WHERE SCHEMA_NAME=’schema_name’
AND SOURCE_TABLE_NAME=’source_table_name’;
“`
官方英文解释
ALL_XSTREAM_TRANSFORMATIONS displays information about all XStream transformations accessible to the current user, in order of execution.
Related View
DBA_XSTREAM_TRANSFORMATIONS displays information about all XStream transformations available on a system, in order of execution.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the rule which has an associated transformation |
|
|
|
|
Name of the rule which has an associated transformation |
|
|
|
|
Type of the transformation:
|
|
|
|
|
Schema to be renamed |
|
|
|
|
New schema name |
|
|
|
|
Table to be renamed |
|
|
|
|
New table name |
|
|
|
|
Schema of the column to be modified |
|
|
|
|
Table of the column to be modified |
|
|
|
|
Column to be renamed |
|
|
|
|
New column name |
|
|
|
|
Column to add or delete |
|
|
|
|
Value of the column to add |
|
|
|
|
Type of the new column |
|
|
|
|
Name of the default function used to add a column |
|
|
|
|
Indicates whether to modify the old ( |
|
|
|
|
Name of the user-defined transformation function to run |
|
|
|
|
DML operation for row subsetting:
|
|
|
|
|
Row subsetting condition |
|
|
|
|
Type of declarative transform to run:
|
|
|
|
|
Execution order relative to other declarative transformations on the same |
|
|
|
|
Order in which this transformation should be executed |
See Also:
“DBA_XSTREAM_TRANSFORMATIONS”
