COLUMN APPLY_NAME FORMAT A30
COLUMN STATE FORMAT A20
COLUMN TRANSACTION_ID FORMAT A20
COLUMN COMMITSCN FORMAT 999999999999999
COLUMN TOTAL_MSG_APPLIED FORMAT 999999999999


SELECT
   APPLY_NAME,
   STATE,
   COMMITSCN,
   TOTAL_MESSAGES_APPLIED TOTAL_MSG_APPLIED,
   APPLY_TIME,
   APPLIED_MESSAGE_CREATE_TIME,
   ELAPSED_APPLY_TIME,sid
FROM
   V$STREAMS_APPLY_SERVER
   WHERE APPLY_NAME LIKE '%'||UPPER('&1')||'%'
ORDER BY
   APPLY_NAME;