Query Regarding XMLAGG

Database
Enthusiast

Query Regarding XMLAGG

Hi,

I am having difficulty in using XMLAGG function from xmlservices,

I am writing query as below,

SELECT SYSXML.XMLAGG(COL1)

FROM (

SELECT            

    SYSXML.XMLELEMENT( 'NAME' ,'XX', TRIM(SUBSTR(DEALERSHIP_NAME,1,6)), '</XX><XX>') AS COL1

FROM CARS_VIEWS.DEALERSHIP

SAMPLE 10

 ) A

the query works fine but only with few records as of now I am running the query for 10 samples

and it is working fine but I want this query without any limit on  sample.

Can someone throw any light on this?

How can this be done?

Regards,

Vinay