[Home] [Help] [Dependency Information]
Object Name: | _DBA_SXGG_TRANSFORMATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_OWNER | VARCHAR2 | (128) | ||
RULE_NAME | VARCHAR2 | (128) | ||
TRANSFORM_TYPE | VARCHAR2 | (26) | ||
FROM_SCHEMA_NAME | VARCHAR2 | (128) | ||
TO_SCHEMA_NAME | VARCHAR2 | (128) | ||
FROM_TABLE_NAME | VARCHAR2 | (128) | ||
TO_TABLE_NAME | VARCHAR2 | (128) | ||
SCHEMA_NAME | VARCHAR2 | (128) | ||
TABLE_NAME | VARCHAR2 | (128) | ||
FROM_COLUMN_NAME | VARCHAR2 | (4000) | ||
TO_COLUMN_NAME | VARCHAR2 | (4000) | ||
COLUMN_NAME | VARCHAR2 | (4000) | ||
COLUMN_VALUE | ANYDATA | (64) | ||
COLUMN_TYPE | VARCHAR2 | (4000) | ||
COLUMN_FUNCTION | VARCHAR2 | (128) | ||
VALUE_TYPE | VARCHAR2 | (3) | ||
USER_FUNCTION_NAME | VARCHAR2 | (4000) | ||
SUBSETTING_OPERATION | VARCHAR2 | (6) | ||
DML_CONDITION | VARCHAR2 | (4000) | ||
DECLARATIVE_TYPE | VARCHAR2 | (13) | ||
PRECEDENCE | NUMBER | |||
STEP_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_OWNER
, RULE_NAME
, TRANSFORM_TYPE
, FROM_SCHEMA_NAME
, TO_SCHEMA_NAME
, FROM_TABLE_NAME
, TO_TABLE_NAME
, SCHEMA_NAME
, TABLE_NAME
, FROM_COLUMN_NAME
, TO_COLUMN_NAME
, COLUMN_NAME
, COLUMN_VALUE
, COLUMN_TYPE
, COLUMN_FUNCTION
, VALUE_TYPE
, USER_FUNCTION_NAME
, SUBSETTING_OPERATION
, DML_CONDITION
, DECLARATIVE_TYPE
, PRECEDENCE
, STEP_NUMBER
FROM SYS._DBA_SXGG_TRANSFORMATIONS;
|
|
|