ALL_STREAMS_STMT_HANDLERS displays information about all statement DML handlers in the database.
DBA_STREAMS_STMT_HANDLERS displays information about all statement DML handlers in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
HANDLER_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the statement handler |
HANDLER_COMMENT |
VARCHAR2(4000) |
Comment specified with the statement handler | |
CREATION_TIME |
TIMESTAMP(6) |
Timestamp for script creation | |
MODIFICATION_TIME |
TIMESTAMP(6) |
Timestamp for script modification |
See Also:
"DBA_STREAMS_STMT_HANDLERS"Note:
TheALL_STREAMS_STMT_HANDLERS view is not available starting with Oracle Database 11g Release 2 (11.2.0.2).