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	Description
`RULE_OWNER`	`VARCHAR2(128)`	Owner of the rule which has an associated transformation
`RULE_NAME`	`VARCHAR2(128)`	Name of the rule which has an associated transformation
`TRANSFORM_TYPE`	`VARCHAR2(26)`	Type of the transformation: `DECLARATIVE TRANSFORMATION` `SUBSET RULE` `CUSTOM TRANSFORMATION`
`FROM_SCHEMA_NAME`	`VARCHAR2(128)`	Schema to be renamed
`TO_SCHEMA_NAME`	`VARCHAR2(128)`	New schema name
`FROM_TABLE_NAME`	`VARCHAR2(128)`	Table to be renamed
`TO_TABLE_NAME`	`VARCHAR2(128)`	New table name
`SCHEMA_NAME`	`VARCHAR2(128)`	Schema of the column to be modified
`TABLE_NAME`	`VARCHAR2(128)`	Table of the column to be modified
`FROM_COLUMN_NAME`	`VARCHAR2(4000)`	Column to be renamed
`TO_COLUMN_NAME`	`VARCHAR2(4000)`	New column name
`COLUMN_NAME`	`VARCHAR2(4000)`	Column to add or delete
`COLUMN_VALUE`	`ANYDATA`	Value of the column to add
`COLUMN_TYPE`	`VARCHAR2(4000)`	Type of the new column
`COLUMN_FUNCTION`	`VARCHAR2(128)`	Name of the default function used to add a column
`VALUE_TYPE`	`VARCHAR2(3)`	Indicates whether to modify the old (`OLD`), new (`NEW`), or both (`*`) values of the LCR
`USER_FUNCTION_NAME`	`VARCHAR2(4000)`	Name of the user-defined transformation function to run
`SUBSETTING_OPERATION`	`VARCHAR2(6)`	DML operation for row subsetting: `INSERT` `UPDATE` `DELETE`
`DML_CONDITION`	`VARCHAR2(4000)`	Row subsetting condition
`DECLARATIVE_TYPE`	`VARCHAR2(13)`	Type of declarative transform to run: `KEEP COLUMNS` `DELETE COLUMN` `RENAME COLUMN` `ADD COLUMN` `RENAME TABLE` `RENAME SCHEMA`
`PRECEDENCE`	`NUMBER`	Execution order relative to other declarative transformations on the same `STEP_NUMBER`
`STEP_NUMBER`	`NUMBER`	Order in which this transformation should be executed