what is the simpler way to generate a rowset...row xml structure with a normal, static query?
Date: Fri, 15 Feb 2008 09:58:51 +0100
Platform: Oracle 10.2.0.3 SE/Linux
I know that using DBMS_XMLGEN I can get query results in a ROWSET..ROW XML structure but I have to feed it with a dynamic SQL string or a ref cursor.
What is the simpler way to generate a ROWSET..ROW XML structure with a normal, static query?
My best shot is:
xmlElement ( "ROW", xmlForest ( first_name, last_name, email ) )
Is there a simpler way? I tried with SYS_XMLGEN but I'm not able to make it work with more than one column.
Thank you. Kind regards, C. Received on Fri Feb 15 2008 - 02:58:51 CST