../E40402-16.epub /> ../E40402-16.mobi />

ALL_STREAMS_STMT_HANDLERS

ALL_STREAMS_STMT_HANDLERS displays information about all statement DML handlers in the database.

Related View

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

Note:

The ALL_STREAMS_STMT_HANDLERS view is not available starting with Oracle Database 11g Release 2 (11.2.0.2).