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