Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Distinct XML Retured in Stored Proc
I have an PL/SQL stored proc that is currently working fine. I need
to modify it so I can use the DISTINCT key word. The SP returns the
results in XML. Here it is. Any help would be appreciated.
SELECT xmlagg(XMLELEMENT("JobNumber", ISR.ISR_NO)) AS "XMLReturned"
INTO xmlTypeRet FROM isr
PM Received on Mon Jul 14 2003 - 14:01:54 CDT