Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
ALL_STREAMS_STMTS
displays information about the statements in all statement DML handlers in the database.
DBA_STREAMS_STMTS
displays information about the statements in all statement DML handlers in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
HANDLER_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the statement handler |
EXECUTION_SEQUENCE |
NUMBER |
NOT NULL |
Execution sequence of the statement |
STATEMENT |
CLOB |
Text of the statement | |
CREATION_TIME |
TIMESTAMP(6) |
Timestamp for statement creation | |
MODIFICATION_TIME |
TIMESTAMP(6) |
Timestamp for statement modification |
See Also:
"DBA_STREAMS_STMTS"Note:
TheALL_STREAMS_STMTS
view is not available starting with Oracle Database 11g Release 2 (11.2.0.2).