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?