VIEW: SYS._DBA_STREAMS_STMTS

Source

View Text - Preformatted

select H.handler_name, S.execution_sequence,
         S.statement, S.creation_time, S.modification_time
  from sys.streams$_stmt_handler_stmts S, sys.streams$_stmt_handlers H
  where S.handler_id = H.handler_id

View Text - HTML Formatted

SELECT H.HANDLER_NAME
, S.EXECUTION_SEQUENCE
, S.STATEMENT
, S.CREATION_TIME
, S.MODIFICATION_TIME
FROM SYS.STREAMS$_STMT_HANDLER_STMTS S
, SYS.STREAMS$_STMT_HANDLERS H
WHERE S.HANDLER_ID = H.HANDLER_ID