SQL & PL/SQL

Hi all,

how do i group values in xml serialization

my query

select xmlserialize(document
             xmlelement("l",
               xmlattributes(locale_code as "id", BASE_FLAG AS "b" , dbms_lob.substr(text) as "d")
             )
             as Nclob indent
           ) as row_data
   from wrk_catalog_rd_l ;

would return something like this

1 <l id=0 b=0 d='abcd'/>
1 <l id=0 b=0 d='abcd'/>
2 <l id=1 b=1 d='abcd'/>

but i need something like this..

1 <l id=0 b=0 d='abcd'/> <l id=0 b=0 d='abcd'/>
2 <l id=1 b=1 d='abcd'/>

your help is appreciated... thank you...