Oracle 视图 ALL_TRANSFORMATIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_TRANSFORMATIONS是一个数据字典视图，用于收集所有用户对象的转换信息。你可以通过它来查询特定用户（或在其他选项下查看所有转换）创建的转换的名称、描述、升级和减少子句等信息。
使用ALL_TRANSFORMATIONS 需要有SELECT_CATALOG_ROLE角色，或者拥有SELECT ANY DICTIONARY类型的系统权限。通过以下SELECT语句可以查看所有用户对象创建的转换：
SELECT TRANSFORMATION_NAME,OWNER,DESCRIPTION,REDUCTION_CLAUSE,UPGRADE_CLAUSE FROM ALL_TRANSFORMATIONS;
官方英文解释
ALL_TRANSFORMATIONS displays information about all transformations accessible to the current user.
These transformations can be specified with Advanced Queuing operations such as enqueue, dequeue, and subscribe to automatically integrate transformations in AQ messaging.
Related Views
-
DBA_TRANSFORMATIONSdisplays information about all transformations in the database. -
USER_TRANSFORMATIONSdisplays information about transformations owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique identifier for the transformation |
|
|
|
|
Owning user of the transformation |
|
|
|
|
Transformation name |
|
|
|
Source type name |
|
|
|
|
Target type name |
See Also:
-
“DBA_TRANSFORMATIONS”
-
“USER_TRANSFORMATIONS”
