set long 2000
select a.name, a.card.extract('/ACARD/EMAIL/text()') as
ramaddresses
from addrbook a
where a.card.extract('/ACARD/@CREATEDBY').getstringval() = 'ram';

