<Counter name1="val1" name2="val2"></Counter>

select
XMLElement
(
"Counter",
    XMLAGG
    (
     (
      select XMLATTRIBUTES('VAL'||level,  'NAME'||level)
      from dual connect by level <= 2
     )
    )
)
from dual;