| 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).