SET SERVEROUTPUT ON

COLUMN id           FORMAT a5   HEADING "Id"
COLUMN recipient    FORMAT a10  HEADING "Recipient"
COLUMN xml_message  FORMAT a45  HEADING "XML Message"

SELECT
    idAttributeOfDocElement(xml_message) AS ID
  , recipient
  , xml_message
FROM
    message
/