[Home] [Help] [Dependency Information]
Object Name: | _DBA_STREAMS_TRANSFORMATIONS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_OWNER | VARCHAR2 | (128) | Yes | |
RULE_NAME | VARCHAR2 | (128) | Yes | |
DECLARATIVE_TYPE | NUMBER | |||
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 | (4392) | ||
COLUMN_TYPE | NUMBER | |||
COLUMN_FUNCTION | VARCHAR2 | (128) | ||
VALUE_TYPE | NUMBER | |||
STEP_NUMBER | NUMBER | |||
PRECEDENCE | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_OWNER
, RULE_NAME
, DECLARATIVE_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
, STEP_NUMBER
, PRECEDENCE
, SPARE1
, SPARE2
, SPARE3
FROM SYS._DBA_STREAMS_TRANSFORMATIONS;
|
|
|