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?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.